topic Re: Date format in Data Load Editor in App Development

Date format in Data Load Editor

balajibc64 — Wed, 29 Mar 2023 09:02:56 GMT

In Qlik Sense, Under Monitoring Apps --> Operation Monitors. I 'm creating new app under my workspace. When I tried to create the initial data load editor page is showing some default format for date and firstday etc. How to change from master level. For Eg. Its showing US format (M/DD/YYYY) but for me it show (DD/MM/YYYY) format. Currently doing manually, how to make a default settings. ?

@Albert_Candelario Could you guide me

Re: Date format in Data Load Editor

AgatheClero — Wed, 29 Mar 2023 09:44:52 GMT

Hi @balajibc64 ,

In the Main section at the beginning of your script, you can define a variable named DateFormat like this :

SET DateFormat='DD/MM/YYYY';

Re: Date format in Data Load Editor

balajibc64 — Wed, 29 Mar 2023 11:46:21 GMT

You are saying like in Data load editor script ? Yes I can able to set. But I'm asking default while loading the editor script page itself format should be like this.

Re: Date format in Data Load Editor

AgatheClero — Wed, 29 Mar 2023 12:02:14 GMT

The default values depend on the settings of your server where Qlik is installed.
Either you have to modify these parameters directly on the server, or you have to modify them manually in each script...

Re: Date format in Data Load Editor

balajibc64 — Wed, 29 Mar 2023 18:12:11 GMT

Either you have to modify these parameters directly on the server. It means ? Also how to setup while installing

Re: Date format in Data Load Editor

balajibc64 — Thu, 30 Mar 2023 13:22:17 GMT

@AgatheClero Could you please any screenshot if possible. Parameter SET DateFormat='DD/MM/YYYY' this i can able to do this. But lookinf default code itself should be in this format

Re: Date format in Data Load Editor

Albert_Candelario — Thu, 30 Mar 2023 14:30:39 GMT

Also have a look at https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/UserInterface/Languages.htm#Setting for Qlik Cloud and

https://community.qlik.com/t5/Official-Support-Articles/How-to-change-Windows-regional-settings-and-have-them-apply-to/ta-p/1710282

Cheers,

Albert

Re: Date format in Data Load Editor

balajibc64 — Sun, 02 Apr 2023 11:39:53 GMT

@Albert_Candelario Just look into this url. After installation Qlik Sense in that particular server also shall we change this setup or else after change the setup need to redo fresh installation ?

Re: Date format in Data Load Editor

Albert_Candelario — Wed, 19 Apr 2023 20:20:25 GMT

@balajibc64 did you already sort out or you still need help here?

Cheers,

Albert

Re: Date format in Data Load Editor

balajibc64 — Wed, 26 Apr 2023 18:20:04 GMT

@Albert_Candelario Need to sort. Put on hold the reason planning to upgrade the latest version. Could you please suggest if anything need to do while installing the software.

Re: Date format in Data Load Editor

Albert_Candelario — Thu, 27 Apr 2023 07:14:55 GMT

Hello @balajibc64 ,
I would recommend to change the regional setting for the service account user of Qlik Sense on the Qlik Sense servers as per you wishing format.

https://community.qlik.com/t5/Official-Support-Articles/How-to-change-Windows-regional-settings-and-have-them-apply-to/ta-p/1710282

Let us know how it goes when performing the upgrade!

Cheers,

Albert