How do I check for 1st day of the year?

[krpurcel]

I have reports that need to check what day of the year it is. On anything other than Jan 1 the reports will pull YTD data. If the date is Jan 1, I want the reports to pull PreviousFullYear. I have played around with DatePart but have not figured out how to do it.

Thanks!

 

[lbass]

Try a formula like this:

(
(
currentdate = date(year(currentdate),1,1) and
year({table.date}) = year(currentdate)-1
) or
(
currentdate <> date(year(currentdate),1,1) and
{table.date} in YearToDate
)
)

It would create a faster report if you first created a SQL expression {%year}:

{fn year(table.date)}

...and then used that instead of year({table.date}) in the formula above.

-LB

 

[fisheromacse]

This is untested and feels incomplete, but something like this...

//check if today is january 1st

if (month(currentdate)=1 and day(currentdate)=1)
then {@PreviousFullYearFormula}
else {@YearToDateFormula}

where you supply the formulas.

 

[krpurcel]

Thanks guys! Your outstanding help is always appreciated!