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