Date Formatting

nchamilton162 — Wed, 26 Apr 2023 12:40:05 GMT

Good morning,

I'm loading a start date variable and Qlik is interpreting it as a decimal. Why is it doing that?

Variable: Let sdate = ‘01/01/2021’;

Result:

I'm also having trouble converting an ascii, text to a date format.
Here are a couple of my attempts at converting from ascii, text to a date. Both convert it to a numeric,integer

Date(Date#(FLAT_DTE_EFF),'MM/DD/YYYY') as new_date

Date(Date#(FLAT_DTE_EFF,'MM/DD/YYYY'),'MM/DD/YYYY') as new_date1

Objective:

I would like to use a rangemax(new_date,$(sdate)) but my end result is a decimal and I can't seem to convert that to a valid date.

Thanks

Re: Date Formatting

marcus_sommer — Wed, 26 Apr 2023 14:01:22 GMT

Your call of: $(sdate) creates a division of 1 / 1 / 2021. To let Qlik it's interpreting as date the variable needs to be wrapped with single-quotes like: '$(sdate)'.

More simple would be to create the variable in this way:

let sdate = floor(makedate(2021));

and then you could call them again per $(sdate).

topic Date Formatting in App Development

Date Formatting

Re: Date Formatting