Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Zenpark_BI
Contributor II
Contributor II

Date picker not working with FR location

Hi, 

(French person here)

 

I'm trying to change the start date of the date picker to =monthstart(addmonths(today(),-1)

As we are the 10th of May 2021 (10/05/2021 in DD/MM/YYYY format), the result of the calcul is 01/04/2021 (DD/MM/YYYY format). But if I apply this, the start date becomes 04/01/2021 (4th of January 2021 in MM/DD/YYYY format).

I've changed the Calendar Settings to 

  • Locale : ='fr'
  • Format ='DD/MM/YYYY'
  • Separator = '/'

In the data load editor 

  • SET DateFormat='DD/MM/YYYY';
  • SET CollationLocale='fr-FR';

 

We use Qlik Sense (February Patch 4)

 

Is there anyway to apply the correct format to the date ? 

Labels (1)
4 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

What happens if you add an Date#() as the interpreter? Does that help?

Jordy

Climber

Work smarter, not harder
Zenpark_BI
Contributor II
Contributor II
Author

Unfortunately no ...

Zenpark_BI_0-1620765303102.png

 

Zenpark_BI_1-1620765329527.png

Still interpreting the date as an US format date instead of not-US date.  

 

Suus
Partner - Creator
Partner - Creator

Hi! Did you figure this one out eventually? I experience the same with language code 'nl' (Dutch) 😞

KuzmenkoDmitriy
Contributor
Contributor

Формат отображения в этих полях настраивается в разделе Язык и метки.

KuzmenkoDmitriy_0-1729944468249.png