Substitute Variable in scheduled database taks

We also have the same problem. Anyone that managed to solve this? 

Hi ​@Arend, ​@lnilsson,

In Reports, CSV values are resolved by the server. The server-side implementation does respect NLS_TERRITORY, which affects the first day of the week.

However, NLS_TERRITORY is set based on the user's language. When the language is changed, NLS_TERRITORY is changed to match the region of that language (per session). This, in return, will change the first day of the week.

For example, if you are in Sweden, you should change your client language to Swedish in order to adjust start and end days according to the regional settings.

These settings cannot be decoupled. At the current stage of IEE support, this behavior will not be modified, as it will require major changes that would impact other parts of the application as well. This will also go beyond a client implementation, as server-side changes will be required as well.

This is considered as a framework limitation.

Hence the workaround for the current issue would be to change the application language to Danish to get the date according to the region Denmark.

I hope this information is helpful.

Thanks,

Sarasi