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
Solved! Go to 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 : )