IF Statement with Dates

[Kristie_Pires]

Hello community,

I am looking to have a formula that says: "If the [Date] is equal to or greater than the 11th of the prior month, then "New Item". Today is 2022-09-28

Date	Comment
2022-09-02	New Item
2022-08-11	New Item
2022-08-09	"Leave blank"

The formula needs to be dynamic. Thank you :) 

[binu_acs · Accepted solution]

@Kristie_Pires One way of doing this

[Emmanuel_G]

@Kristie_Pires 

Find in attachement the way of doing that.

[Kristie_Pires]

Thank you @binu_acs - it worked for my situation! 

I understood how the formula works except for the "7". I might have to use something similar in the future and I want to grasp it ;) 

[binu_acs]

@Kristie_Pires Let me explain the formula in detail

Left(toDate(DateTimeAdd(DateTimeToday(),-1,'Month')),7)+'-11', 'New Item','')

DateTimeAdd(DateTimeToday(),-1,'Month') - will return the previous month

ToDate() - function will convert the above DateTime value to just Date value (The time part will be ingnored)

Left() - function used to take from left to 7 character length. For example Left('2022-09-02',7) returns first 7 characters i.e 2022-09

[Kristie_Pires]

Thank you both for helping me out! @binu_acs Thanks for explaining so that I can replicate the formula in the future 😊