Can some one help me to convert add_months(trunc(to_date('01/01/2015','dd-mm-yyyy'),'yy'),12)+17 to equivalent SQL expression in Cyrstal Report ?

[Former Member]

I have used  add_months(trunc(to_date('01/01/2015','dd-mm-yyyy'),'yy'),12)+17  in report query.

Now I have to use this in one formula (report level) to compare the dates.

Please help me to find equivalent SQL expression for this.

- Prashanth

[abhilash_kumar · Accepted solution]

Hi Prasanta,

The formula would look something like this:

cdate(year(date(2015,01,01))+1, 01,01) + 17

-Abhilash

[Former Member · Accepted solution]

Thanks Abhilash. It is working.