Add the time to a date field

Question

This one should be pretty easy, but I can't quite find the right response already in a Community discussion.  I have two fields.  One is a DateTime format with zeroes for hours, minutes and seconds, e.g. 2021-04-25 00:00:00.  The other field is a Time format with hours, minutes, and seconds, e.g., 19:11:10.  I just want to add the hours, minutes and seconds in the Time field to the DateTime fields so I end up with 2021-04-25 19:11:10.  Thanks for the assist!!!

atcodedog05 · Accepted Answer

Hi @oracleoftemple

Here is a formula on how you can do it.

datetimeparse(datetimeformat([Date],"%Y-%m-%d")+ [time],"%Y-%m-%d%H:%M:%S")

Workflow:

datetimeparse(

datetimeformat([Date],"%Y-%m-%d")            // Taking only date from datetime format

+ [time]                                                           // Concating time value

,"%Y-%m-%d%H:%M:%S")                            // Converting it to datetime

Hope this helps 🙂