Valid datetime format entry in Domo Online Form

zaif_chew

When using the Domo Online Form as a dataset, what is the text format used to input in a valid datetime entry in order for DOMO to recognize it properly as datetime?

 

I've tried the following but it is only able to recognize the date but not the time:

2015-05-26 10:30:00.0+00

2015-05-26 10:30:00

2015-05-26 10:00:00AM

PEAKS_valleys

@zaif_chew

 

1. I replicated your webform and used this in the MySQL dataflow. 

 

2. I used the CONVERT function to change the data type to datetime and then renamed the column to `launch_date2`

 

 

3. Just showing that the `launch_date` field was changed to a date in `launch_date2`

 

Hope this helps! 

PEAKS_valleys

@zaif_chew - 

 

have you tried   mm/dd/yyyy hh:mm:ss ?

 

I just created a webform using this date time format. As a QA I was able to use a beast mode to remove the time component. 

 

Hope this helps!

 

zaif_chew

@PEAKS_valleys

 

Thank you for the reply.

 

I actually need to manipulate it at the Dataflows Transform level (for comparison with timestamps from other inputs).

 

I ran the following query as a test to check if it is a valid date.

It seems to still recognize the manual timestamp entries as text instead of datetime. 

PEAKS_valleys

@zaif_chew

 

1. I replicated your webform and used this in the MySQL dataflow. 

 

2. I used the CONVERT function to change the data type to datetime and then renamed the column to `launch_date2`

 

 

3. Just showing that the `launch_date` field was changed to a date in `launch_date2`

 

Hope this helps!