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

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.

Solved Solved
0 1 120
1 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"))

View solution in original post

1 REPLY 1

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"))

Top Labels in this Space