max(Date)-1 not working

[bhavvibudagam]

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]

Hi,

try this for Max date -1:

=Date(Max(Date)-1)

[shiveshsingh]

Try Date(Max(Date)-1)

[ashwinishinde · Accepted solution]

Try this,

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

[buzzy996]

pfa

[isingh30]

Please check this.

The Date Function

Thanks.