Choose Current Year

hi, i have an issue to identify current year in the table.

Let say today is in 2017, but I want to identify 2016 as Current Year and then will be filtered out.

This workflow should be flexible with the update of the year. For example, if we are in 2018, the Current Year then will be 2017.

i have tried to use max function but seems it is not working.

test.xlsx

Date Time

Accepted answers

JoeS

Hi @azuzu

I have written it into one formula for you in the attached workflow.

The formula is:

IF
ToNumber(DateTimeFormat(DateTimeToday(),"%Y")) - [Year] = 1
Then "Yes"
ELSE "No"
ENDIF

To break it down, I used: DateTimeFormat(DateTimeToday(),"%Y") to get the year from today's date. I then need to ToNumber this as Alteryx treats dates as string values.

Then you can perform your if statement that you had previously.

Hopefully this helps.

Thanks

Joe

compare years_js.yxmd

All comments

azuzu

This is the output that I have worked on. Is there any other simpler way to do such this thing?

Years Comparison.yxzp

JoeS

Hi @azuzu

I have written it into one formula for you in the attached workflow.

The formula is:

IF
ToNumber(DateTimeFormat(DateTimeToday(),"%Y")) - [Year] = 1
Then "Yes"
ELSE "No"
ENDIF

To break it down, I used: DateTimeFormat(DateTimeToday(),"%Y") to get the year from today's date. I then need to ToNumber this as Alteryx treats dates as string values.

Then you can perform your if statement that you had previously.

Hopefully this helps.

Thanks

Joe

compare years_js.yxmd

vishwa_0308

Hi,

You can use this expression and this will give you previous year as a result.

DateTimeFormat(DateTimeAdd(DateTimeNow(),-1,"Year"),"%Y")

Regards,

Vishwa

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703