topic Re: max(Date)-1 not working in QlikView

max(Date)-1 not working

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me on below requirement. I have a date field like DD MMM YY Format

for max(Date) getting 22 Feb 18 correctly but for Max(Date)-1 getting 43152 instead of 21 Feb 18.

Please help me on converting number to 21 Feb 18 format

Thanks in advance

YoussefBelloum — Thu, 22 Feb 2018 09:41:37 GMT

Hi,

try this for Max date -1:

=Date(Max(Date)-1)

shiveshsingh — Thu, 22 Feb 2018 09:47:53 GMT

Try Date(Max(Date)-1)

ashwinishinde — Thu, 22 Feb 2018 09:54:10 GMT

Try this,

=date(max(Date)-1,' DD MMM YY')

buzzy996 — Thu, 22 Feb 2018 13:33:06 GMT

pfa

isingh30 — Thu, 22 Feb 2018 13:41:21 GMT

Please check this.

Thanks.