Year and date

[satyam28]

Hi Team I want to build a academic year from the date of birth and the solution should be in the below format - how to get he academic year as year 3 , year 2 and so on

• Year 1 is anyone born after 1st Sept 2014 
• Year 2 is anyone born between 1st Sept 2013 and 31st Aug 2014 etc
• Year 3 is anyone born between 1st Sept 2012 and 31st Aug 2013 etc

Thanks in advance 

[atcodedog05]

Hi @satyam28 

Here is how you can do it. Provided date is in proper format. If not please provide sample data.

Workflow:

Hope this helps : )

[satyam28]

Please find the sample date

[atcodedog05]

Hi @satyam28 

Here is the updated workflow. Category for before 1st Sept 2012 is not defined.

Hope this helps : )