Previous Date

[#1]

Dear Community,

I would like to get the previous date information, instead of date - 1, anyone has idea on this?

perhaps some simple functions...

Sample attachment:

I would like to see 6/3/2014 in PrevDate column, instead of 6/4/2014 as yellow highlighted below.

Thanks,

Chanel

[Anonymous · Accepted solution]

Hi,

Try "Previous(Date) as PrevDate" instead of "Date - 1 as PrevDate"

[ashfaq_haseeb]

Hi,

May be like this look at the attached.

Regards

ASHFAQ