topic Re: Date(Today())-1 returns 44146 and DATE(WEEKSTART(Today()) - 4,'M/D/YYYY'))-3 returns 44135 instead of date format in QlikView

Date(Today())-1 returns 44146 and DATE(WEEKSTART(Today()) - 4,'M/D/YYYY'))-3 returns 44135 instead of date format

Qlikandlearn — Fri, 15 Nov 2024 23:38:21 GMT

Hi,

I'm trying to compare the data based on the date condition in where clause, I've used DATE(WEEKSTART(Today()) - 4,'M/D/YYYY'))-3, but it returns 44137 instead of 11/2/2020

Any idea why it is returning number?

Thanks in advance.

Re: Date(Today())-1 returns 44146 and DATE(WEEKSTART(Today()) - 4,'M/D/YYYY'))-3 returns 44135 instead of date format

MayilVahanan — Fri, 13 Nov 2020 01:23:47 GMT

Hi @Qlikandlearn

DATE(WEEKSTART(Today()) - 4,'M/D/YYYY'))-3 <-- After date format, you are subtracting with number (-3), so its gives number instead of dateformat. Each date has number format.
So instead of above,
try with

DATE(WEEKSTART(Today()) - 4,'M/D/YYYY'))-3 --> =DATE(WEEKSTART(Today()) - 7,'M/D/YYYY')

Date(Today())-1 --> =Date(Today()-1)