Can you please tell me how to filter YTD in report studio or FM.
Hi esanray,
Try this in RS, in a filter on a date field:
[YOUR_DATE] >= trunc(current_date,'Y')
yes that correct, if i go for last 5 years filter what is the syntax?
[date] between _add_months(current_date,-60) and current_date will give you 60 months data.. is this what you required or do you expect some other calculation
Regards,
Nag
Graph total number of disrupted guest comparison for financial year versus past 5 financial years broken down per month, this my requirement
Graph total number of disrupted guest comparison for financial year versus past 5 financial years broken down per month, this report is run 1st of every month with compare to the last 5 years brolken down in months.