date format problem

[doespirito]

Hello,

here is a variable :

here is the selected date :

when I create a text box from this variable, the date seems to be correctly recognized  :

but actually this is what I get :

with the date format it's not better :

Is there anyone to help me?

Thank you

Arnault

[mpc]

Hello, 

Try Date(Date#('$(v_datedebut)','DD/MM,YYYY')) ?

Regards

[diegozecchini]

Hi!I suggest a checklist of things to verify:

-Ensure that GetFieldSelections(date1) retrieves the date in the expected format. Sometimes, formats can cause unintended transformations if not set consistently across the application.
-When creating the text box, ensure that the expression uses a date formatting function like Date() in Qlik. For example, you could try:

=Date($(v_datedébut), 'DD/MM/YYYY')
This might enforce the correct display format.

-Check your application's default date format settings. Sometimes, the date format in the environment may override specific formatting in expressions.

Sometimes, when variables are derived from expressions like GetFieldSelections, they might not directly behave as dates but as strings. Applying a Date() function explicitly can help force it to interpret as a date.

[maxgro · Accepted solution]

0,000494 is 10/10/2024 (10 divided by 10 divided by 2024)

so you probably lack '' in the variable

try '$(variable)' instead of $(variable)

[seanbruton]

Superb!!!