Updating in bulk variables used in many qvws

[paul_ripley]

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

[paul_ripley]

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;