Skip to Content
0
Aug 19, 2013 at 08:30 AM

#ERROR Coming with date

24 Views

Hi Experts,

I am using the below logic to get the previous year starting date:

=ToDate("4/01/"+FormatNumber(Year(ToDate([L01 Billing doc. date]Where(Year([L01 Billing doc. date])=Year(CurrentDate())-1);"M/dd/yyyy"));"####");"M/dd/yyyy")

This Logic is working fine but giving the #ERROR with date like below picture:

How to resolve this.

Thanks,

G Sampath Kumar

Attachments

Capture.JPG (11.1 kB)