Update year in a filter based on current year-1 using datetimenow

[hash_89]

I would need to update a filter to 'current year - 1'. Is there a way to do it with using 'datetimenow'?

How can i connect this to update 'Filter' with this 'Year' value? Can someone help me on this?

My intention of using 'datetimenow' is because i don't want to manually add anything to my workflow before i schedule it.

Thanks.

[Thableaus]

Hi @hash_89 

You can use the DateTimeYear function.

DateTimeYear(DateTimeNow()) - 1

Cheers,

[Thableaus]

@hash_89 

How's your filter setup?

Cheers,

[hash_89]

Hi,

I have certain input coming through. The filter which has year = 2019 should dynamically change to 'Current year -1'. I have two different pieces now and I'm looking for ways to connect them both either through interface or other means.

[Thableaus · Accepted solution]

@hash_89 

You don't need the Action tool for that.

In the Filter Tool, select the Custom Filter Option.

[year] = DateTimeYear(DateTimeNow()) - 1

Done, you'll have what you desire.

Cheers,

[hash_89]

Thankyou.