Code for last day of current year

[KEKeogh]

I have been using "_make_timestamp(extract(year,current_date),1,1)" in formulas and query calculations to have a report start at the 1st day of the year.

Now I need something similar for the last day of the year.

I tried "_make_timestamp(extract(year,current_date),12,31)" but that didn't work.

I'm using 8.3.

Thanks

[blom0344]

Code Select Expand


_add_days(_make_timestamp(extract(year,current_date)+1,1,1),-1)