Taras
asked on
Crystal Report Last Year YTD full month
In creating YTD Last Year full month formula.
Formula1:
If ({table1.Start_Date} in Date (Year(CurrentDate) -1, 01, 01) to DATEADD(year(CurrentDate), -1, CurrentDate - Day(CurrentDate))) then
{Table1.Amount}
Else
0;
I am getting error in part: DATEADD(year(CurrentDate), highlight is on Year(CurrentDate) and error is String is required here
Any Idea?
Formula1:
If ({table1.Start_Date} in Date (Year(CurrentDate) -1, 01, 01) to DATEADD(year(CurrentDate),
{Table1.Amount}
Else
0;
I am getting error in part: DATEADD(year(CurrentDate),
Any Idea?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot
ASKER
date field in dateserial(year(currentdat
But I was wondering what is wrong with my formula.?