This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

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

Posted on 04-10-2023 09:12 AM
Dubams
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

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 4 261
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

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

Jump to Solution
4 REPLIES 4
Top Labels in this Space