Crystal Enterprise formula implement

[former_member449282]

Hi Experts,

This following formula already implemented in Crystal Report, we would like to now we need to Implement in Crystal Enterprise..

if datevalue({DAILY_ORDERS_BY_ENTRY_DATE_ST.FORECAST_DATE}) < datadate - 60 then 'PRIOR'
else if {DAILY_ORDERS_BY_ENTRY_DATE_ST.FORECAST_DATE} > datadate + 60 then 'FUTURE'
else totext(datevalue({DAILY_ORDERS_BY_ENTRY_DATE_ST.FORECAST_DATE}))

How to do use this formula in Crystal Enterprise.

Thanks in Advance Experts, this is little urgent pls give me solution on this.

Regards,

Bharath

[abhilash_kumar]

Hi Bharathi,

Try:

if Date({DAILY_ORDERS_BY_ENTRY_DATE_ST.FORECAST_DATE}) < datadate - 60 then 'PRIOR'
else if Date({DAILY_ORDERS_BY_ENTRY_DATE_ST.FORECAST_DATE}) > datadate + 60 then 'FUTURE'
else totext(Date({DAILY_ORDERS_BY_ENTRY_DATE_ST.FORECAST_DATE}), 'yyyy/MM/dd')

-Abhilash