Skip to Content
avatar image
Former Member

Crystal Enterprise formula implement

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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