Dateadd Formula date and hours

[Franck_pasques]

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

[Vivid-Squid]

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]

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

Airtable

Production séjours copy - Airtable

Explore the "Production séjours copy" view on Airtable.

[Vivid-Squid]

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

[Franck_pasques]

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

Airtable

Vue airtable aide community - Airtable

Explore the "Vue airtable aide community" view on Airtable.

[Vivid-Squid]

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.

[Franck_pasques]

Vivid-Squid:

hours

I tried but without success thank you for your help

[Vivid-Squid · Accepted solution]

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

[Franck_pasques]

Cela fonctionne ! Merci beaucoup bien cordialement :grinning: