date format changed

[stekol61]

Hi!

I have a QlikView app with several graphs.
I'm using a variable (below) for the time dimension in all graphs
It is possible to switch between 'Day', 'Week' and 'Month'

For some reason the date format has changed from e.g '2019-01-20' to '43485' in all graphs.

'Week' and 'Month' format is OK.

Any suggestion?

=if(v_period='Day', 'Date',
if(v_period='YearWeek','YearWeek',
if(v_period='YEARMONTH', 'YEARMONTH')))

[juraj_misina]

I'd say that the format changed in source data. To make sure try format the Date field with Date() function in script and see if that helps.
Juraj

[MindaugasBacius · Accepted solution]

Maybe the change in Document Properties > Number formatting may do the job. Have you tried it?