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

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


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