Valid datetime format entry in Domo Online Form

zaif_chew · July 2016

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 · July 2016

@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 · July 2016

@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 · July 2016

@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 · July 2016

@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!

Valid datetime format entry in Domo Online Form

Best Answer

Answers

Categories