Skip to Content
avatar image
Former Member

Crystal Enterprise formula implement

Nov 09, 2017 at 09:36 AM | 18 Views

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

SAP Crystal Reports
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Abhilash Kumar
    Nov 09, 2017 at 02:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded