• Sign In

xsd:dateTime

Study Forum (Inactive)

View Message

view list print
xsd:dateTime wnels2  2009-01-31 19:37
Status: Closed
 
I'm trying to create a dateTime field for time only.
I entered the format "hh aa" to represent, for example, 04 pm.
The error message is - Could not convert value: 04 pm.
Can you please give me an example of how to format a time correctly and tell me why this is not working?
Thanks,
Bill
 
 
Karl Lum responded:  2009-02-02 14:35
Our date parser doesn't recognize time only date strings.

You would need to enter a valid date portion even though you were only displaying time only, so for your example you could enter a value of: 2/2/09 4:00 PM in order to display '04 PM' using your format string.