Help

Dateadd Formula date and hours

Topic Labels: Formulas
Solved
Jump to Solution
2957 8
cancel
Showing results for 
Search instead for 
Did you mean: 
Franck_pasques
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, I have two fields with two different formulas:

Field 1:DATEADD({Date morning Start},{Number of days},‘d’)

Field 2:
DATEADD({Date am Start},‘4’,‘hours’)

I would like to have only one field grouping these two formulas

Also, I have a third formula field but the formula doesn’t work on either the date or the time:
If({field date}, 09:00, ‘true’, ‘false’)

Thank you for your answer

1 Solution

Accepted Solutions
IF(DATETIME_FORMAT(DATEADD(Date, {Number of Days}, 'days'), 'LT') = '9:00 AM', 'True', 'False')

See Solution in Thread

8 Replies 8

Hi @Franck_pasques
Are {Date morning Start} and {Date am Start} supposed to be the same field? Or is the name of field 1 {Date am Start}?

Your IF formula will not work as you have it. There are too many arguments in it. I think you meant to have IF({field date} = ‘09:00’, ‘true’, ‘false’) but i am not sure what type of field {field date} is.

Franck_pasques
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello Thank you for this feedback,
I am attaching a photo of the table

Field 1 - calculates the fields ;Date morning Start and number of days

Field 2 - calculates Date morning Start, + 4 hours

I would like fields 1 and 2 to combine the two formulas

On the field - Calculating Morning and AM copy the form does not work IF({Date morning Start} = ‘09:00’, ‘true’, ‘false’)

Thank you

OK, here you go

Date AM Start

DATEADD(Date, {Number of Days}, 'days')

Next

DATEADD(DATEADD(Date, {Number of Days}, 'days'),4,'hours')

Get the time

DATETIME_FORMAT(DATEADD(DATEADD(Date, {Number of Days}, 'days'),4,'hours'), 'LT')

Finally

IF(DATETIME_FORMAT(DATEADD(DATEADD(Date, {Number of Days}, 'days'),4,'hours'), 'LT') = "9:00 AM", 'True', 'False')

image

Great, thank you !
everything works :grinning: except grinning: true or false I attach the link to the table

My apologies. I misread your post. In my formula the True false is looking at the “Just Time” field. You should be able to adjust it to pick up the Date am Start field. Do you want to give it a try? If you cant get it, I can fix it tomorrow.

I tried but without success thank you for your help

IF(DATETIME_FORMAT(DATEADD(Date, {Number of Days}, 'days'), 'LT') = '9:00 AM', 'True', 'False')

Cela fonctionne ! Merci beaucoup bien cordialement :grinning: