How to get previous financial year's last month dynamically

[prakhar_21]

Hi All, This is regarding the help needed for an urgent requirement, I want to fetch previous financial year 's last month i.e March.  for example now is may so I want  match. This is should be totally dynamically  no hardcoding. Can anyone please help in in this. Its an urgent requirement. Please help 

[Chanty4u]

Can you explain with example.

But as per my understanding below you can give a try 

LET vToday = Today(); 

LET vPrevFY = IF(Month(vToday) <= 3, Year(vToday) - 2, Year(vToday) - 1);

LET vPrevFYLastMonth = Date(MonthEnd(MonthStart(Month(vToday)-3, vPrevFY)), 'MMM');

Use the vPrevFYLastMonth variable in expression 

[prakhar_21]

Example is -: Financial Year = Prev Fiancial Year - Apr 2022 - March 2023, Current Financial Year - Apr 2023 - March 2024, Currently We're in May so I want to fetch last Financial year's last month  that is MARCH that too dynamically