Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have the same variables that I used across many apps that update the period.
I have to go into each app every month and update them with the new period.
Is there a way to do this in bulk? I believe there is away using excel but I don't know how to do this. Is that the best way?
Many thanks
Paul
Hi All
Thanks for your help.
In the end I used a script in that I load into all the apps.The script is held in a config file and loaded in
Many thanks
Paul
//Config File
$(Include=..\..\06_sys\config\config_userapp_accountmodel.txt);
//
// Calculate Current Periods
//
Let vCurrentPeriod=MonthStart(Addmonths(Today(),-4));
Let vStartPeriod_CY=(Year(vCurrentPeriod)*100);
Let vEndPeriod_CY=(Year(vCurrentPeriod)*100)+num(month(vCurrentPeriod),'00');
Let vStartPeriod_PY=((Year(vCurrentPeriod)-1)*100);
Let vEndPeriod_PY=((Year(vCurrentPeriod)-1)*100)+12;
Let vStartPeriod_IS_CY=(Year(vCurrentPeriod)*100)+1;
Let vStartPeriod_IS_PY=((Year(vCurrentPeriod)-1)*100)+1;