Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys, I hope you can help me. I have these variables in a App.
let vDateToday = date(floor(now()));
let vDateStartMTD = date(makedate(year(vDateToday),month(vDateToday),1));
let vDateStartYTD = date(makedate( if( month(vDateToday)<=2,year(vDateToday)-1,year(vDateToday) ), 3, 1 ));
let vDateStartYTDPY = date(makedate( if( month(vDateToday)<=2,year(vDateToday)-1,year(vDateToday)-1 ), 3, 1 ));
let vDateEndYTDPY = date(MonthEnd(makedate( if( month(vDateToday)<=2,year(vDateToday)-1,year(vDateToday) ), 2, 1 )));
How do I create one that looks at the Financial year as a whole? I want to create a button than says Full Financial year!
I currently have Year to Date , Year to date - Prior Year & Month to Date. I want to create a (Full Financial Year Button)
Hope you can help me
If you look at the function InYearToDate you will see that you can set the period for when your fiscal year begins.
You can add that as another flag in your load script that relates to the Fiscal Year.
Hi, thank you. Can you maybe provide me with an example?
Our Fiscal Year runs from 1-March to 29-Feb each year.
Kind regards
Here are a whole bunch of samples. Search for InYearToDate and you will see example of Fiscal Year in October (month 10)