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

Date formula

Posted on 07-31-2020 11:03 PM
Mrdan29
New Member
Reply posted on --/--/---- --:-- AM

Help I want to Make a date/time column when it’s empty then it filled with date/time(from other date/time column+1day (wtih specific time of 12.00AM)

so its like
column 1
1/01/2020 07.00.00 AM

then the column I want if emptie will have column 1 + 1 day
1/02/2020 but i want the time always says 12.00.00 AM

0 4 283
Topic Labels
0 Likes
4 REPLIES 4

Posted on --/--/---- --:-- AM
hru
Gold 1
Gold 1
Reply posted on --/--/---- --:-- AM

Maybe you can use below in an app formula:

IFS(ISBLANK([ColumnYouWant]), DATETIME(DATE([Column 1])+1) )

Posted on --/--/---- --:-- AM
Mrdan29
New Member
In response to hru
Reply posted on --/--/---- --:-- AM

Thank you so much Mate

Posted on --/--/---- --:-- AM
Steve
Platinum 5
Platinum 5
Reply posted on --/--/---- --:-- AM

For reference:





Posted on --/--/---- --:-- AM
Mrdan29
New Member
In response to Steve
Reply posted on --/--/---- --:-- AM

Thank you steve

Top Labels in this Space