Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Number of months

Tid14
8 - Asteroid

Hi,

I am working on a WF wherein i need total number of months since Jan 21 till today’ month then every month it will be adding up to the number with each passing month.

1 REPLY 1
DataNath
17 - Castor
17 - Castor

Hey @Tid14, you should be able to use the following expression in a Formula tool which will dynamically give you the number of months since Jan 21:

 

DateTimeDiff(DateTimeToday(),'2021-01-01','month')
Labels
Top Solution Authors