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 DateComment 2022-09-02New Item2022-08-11New Item2022-08-09"Leave blank" The formula needs to be dynamic. Thank you :)

IF Statement with Dates

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

Date Time

Help

Accepted answers

binu_acs

@Kristie_Pires One way of doing this

DateFilter_0928.yxmd

All comments

binu_acs

@Kristie_Pires One way of doing this

DateFilter_0928.yxmd

Emmanuel_G

@Kristie_Pires

Find in attachement the way of doing that.

Alteryx_Question.yxmd

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 😊

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703