Discussion Board for collaboration related to QlikView App Development.
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
Hi,
try this for Max date -1:
=Date(Max(Date)-1)
Try Date(Max(Date)-1)
pfa