Expression for if it's been more than 2 weeks since the last inventory check

[Shannon_Winter_]

I’m trying put in an expression for date last checked being more than 2 weeks. What am I doing wrong? The column of ‘Date Checked’ is set to date in appsheet.

[Suvrutt_Gurjar]

It sounds you are using Yes/No type column to check the date aging beyond 14 days.

IFS([Date Checked]<TODAY()-14, TRUE)

Will retrun true or Y on the button of (Y/Ntype colum) with the above expression when the date is older than two weeks from today’s date.

[Marc_Dillon]

Suvrutt_Gurjar:

IFS([Date Checked]<TODAY()-14, TRUE)

In most cases, the IFS() here is extraneous, unless for some reason you’d prefer a blank instead of a FALSE value. Can just use:

[Date Checked]<TODAY()-14

[Suvrutt_Gurjar]

Good point @Marc_Dillon. Thank you. Yes, Y/N column expression is similar to constraint settings of columns where IF is already built in so extra IF is unnecessary.

[Shannon_Winter_]

Thanks so much both of you! Got it working with the [Date Checked]<TODAY()-14 formula:)