Valid datetime format entry in Domo Online Form

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

Best Answer

  • PEAKS_valleys
    PEAKS_valleys Member
    Answer ✓

    @zaif_chew

     

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

     

    webform_input.png

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

     

    launch_date_correct.png

     

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

    launch_date_as_date.png

     

    Hope this helps! 

Answers

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

     

  • @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. 

    pic1.png

  • PEAKS_valleys
    PEAKS_valleys Member
    Answer ✓

    @zaif_chew

     

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

     

    webform_input.png

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

     

    launch_date_correct.png

     

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

    launch_date_as_date.png

     

    Hope this helps!