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! Go to 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"))
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"))
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |