# IF Formula using dates

Topic Labels: Formulas
Solved
1594 5
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hello all,

I would like to use an If formula:

Everything before a certain date should be “True”, everything after “False”.

When I write it like this, it doesn’t work:

IF(InvoiceDate<3/8/2021,1,2) (InvoiceDate is a Field in Type “Date” with Format “European”).

Do you have any idea and could you help me please? Thank you very much!

1 Solution

Accepted Solutions
12 - Earth

Airtable doesn’t recognise the “3/8/2021” as a date witch which it can work. You have to convert it into a date type using `DATETIME_PARSE()`.

This should work:

`IF(InvoiceDate<DATETIME_PARSE("03-08-2021", "DD-MM-YYYY"), 1, 2)`

5 Replies 5
12 - Earth

Airtable doesn’t recognise the “3/8/2021” as a date witch which it can work. You have to convert it into a date type using `DATETIME_PARSE()`.

This should work:

`IF(InvoiceDate<DATETIME_PARSE("03-08-2021", "DD-MM-YYYY"), 1, 2)`

5 - Automation Enthusiast

That has worked before. Now I immediately encountered another problem: I want to connect the IF function with another IF function.

If I do this as described below, the result is always “0”, even if the amount should be different.

Could you maybe help me again please? Thank you very much! :slightly_smiling_face:

IF(InvoiceDate<DATETIME_PARSE(“03-08-2021”, “DD-MM-YYYY”), (IF((SUM(PaymentAmount,{CurrencyDifference})/{InvoiceAmount})=1,0,{InvoiceAmount}-PaymentAmount)), 0)

12 - Earth

Try

`IF(InvoiceDate<DATETIME_PARSE(“03-08-2021”, “DD-MM-YYYY”), IF(SUM(PaymentAmount,{CurrencyDifference})/{InvoiceAmount}=1,0,{InvoiceAmount}-PaymentAmount))`

5 - Automation Enthusiast

Hey @Databaser.

This working very well. Thank you so much!

12 - Earth

Glad I could help! Would yo mind marking my comment as the solution to your question? This helps others who may be searching with a similar question. Thanks!