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.

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

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

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

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

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

Great, thank you !


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

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

Cela fonctionne ! Merci beaucoup bien cordialement