IF Formula using dates

[Sebastian_Apel]

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!

[Databaser]

Hi @Sebastian_Apel

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)

[Sebastian_Apel]

Hi @Databaser , thanks for your quick and good answer!

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!

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

[Databaser]

@Sebastian_Apel

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

Try

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

[Sebastian_Apel]

Hey @Databaser.

This working very well. Thank you so much!

[Databaser]

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!