In a Generic Inquiry, I'm trying to format the time part of a DateTime field in the results. I don't currently see any way to do this without parsing the date as a string, but I must be missing something. Using the Format() function, running the query tells me "The method or operation is not implemented". Using the Minute() function gets the minutes part, but using the Hour() function says "Unsupported formula operator Hour".
0
votes
What is the desired format you are trying to get in the result?
- Casval
I tried to do this in 6.1 and never found a solution. GI's cannot use time format correctly. The only way I got this to work was to create an unbound field that would format a string field to display the time which seems clunky.
- Brendan
Casval, simply hour and minute format, 12-hour with AM/PM would be best, but just can't get the hour portion without parsing.
- Tony Lanzer
Thanks Brendan, that at least confirms my issue, and I may do the same.
- Tony Lanzer