DATE FORMULA

[ssiroky]

I have a date format of {1/1/2004 12:00:00AM}. I'm currently using the formula: Year ({INCIDENTS.REPORT_DATE}) which gives me a numerical value ex. 2004 However, when I use this formula in another formula, it tells me I need to place a number here. Obviously I need to convert this value to a text field so I can do the argument of

IF {@MONTH} = 'JAN' THEN 1 ELSE
IF {@YEAR} = '2004' THEN 1 ELSE 0

Any ideas on how to do this? Thanks for any help.

 

[crystalreporting]

ToText(Year ({INCIDENTS.REPORT_DATE}),0,"")

or change your second formula to not look for text e.g.

IF {@YEAR} = 2004 THEN 1 ELSE 0


Peter Shirley

http://www.linkcorp.com

 

[ssiroky]

THANK YOU SO MUCH...THAT WORKED