YTD

[esanray]

Can you please tell me how to filter YTD in report studio or FM.

[jcrouch]

Hi esanray,

Try this in RS, in a filter on a date field:

Code Select Expand

[YOUR_DATE] >= trunc(current_date,'Y')

[esanray]

yes that correct, if i go for last 5 years filter what is the syntax?

[167505]

[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

[esanray]

Graph total number of disrupted guest comparison for financial year versus past 5 financial years broken down per month, this my requirement

[esanray]

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.