Extract month number

[Adarsh_R3]

Hi, I would like to extract the month number from a date field. 

But the financial year starts in July and ends in  June. A sample is shown below.

Month	Month Number
12-07-2020	1
15-06-2021	12
16-12-2020	6

 If this is possible could anyone assist me Thanks in advance

[atcodedog05 · Accepted solution]

Hi @Adarsh_R3 

Here is how you can do it. I am calculating the actual month no and adjusting it to financial month no start is july and end is june.

Workflow:

Hope this helps : )