Datetime Expression to set inital datetime to 12 noon the next day

[Dubams]

I have been trying to write a datetime expression for 12 noon tomorrow (the next day).  

My various attempts have not given what I want.

[Suvrutt_Gurjar · Accepted solution]

Please try the below if the desired date format is MM/DD/YYYY

DATETIME(CONCATENATE(TEXT(TODAY()+1,"MM/DD/YYYY")," ","12:00:00"))

Please try the below if the desired date format is DD/MM/YYYY

DATETIME(CONCATENATE(TEXT(TODAY()+1,"DD/MM/YYYY")," ","12:00:00"))

[d-grigsby]

I am having an issue with datetime for a linktoform actions: below is my expression.  When initiate the action it leaves the "Work Start Time" and "Work End Time" blank.  Not sure what I'm doing wrong.  I want it to use the Date of the current row and combine it with a specific time, 8:00 am and 4:00 PM for each of the respective columns.

LINKTOFORM("TimeCard_Form","Driver",[Driver],"TimeCard ID"=(UNIQUEID()&UNIQUEID()),"Date"=[Date]+1,"Work Start Time"= DATETIME(CONCATENATE(Text([Date]+1,"MM/DD/YYYY")," ","08:00:00")), "Work End Time" = DATETIME(CONCATENATE(Text([Date]+1,"MM/DD/YYYY")," ","16:00:00")))

[Steve]

Try this:

LINKTOFORM("TimeCard_Form","Driver",[Driver],"TimeCard ID",(UNIQUEID()&UNIQUEID()),"Date",[Date]+1,"Work Start Time", DATETIME(CONCATENATE(Text([Date]+1,"MM/DD/YYYY")," ","08:00:00")), "Work End Time" , DATETIME(CONCATENATE(Text([Date]+1,"MM/DD/YYYY")," ","16:00:00")))

[d-grigsby]

Works perfectly.  Thanks Steve!