Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try this,
=date(max(Date)-1,' DD MMM YY')
pfa