Skip to Content
0

Crystal Enterprise formula implement

Nov 09, 2017 at 09:36 AM

17

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Nov 09, 2017 at 02:55 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded