forums

We frequently report crime data that compares this year to date with last year to date. While we can filter on months and weeks to come close to a year to date, it would be more precise to have the ability to use a Julian date (that is, a counter of the days in the year, starting with 1 for January 1st and ending with 365 or 366 for Dec 31st). It would be ideal if this could be a choice in the "More" options for date displays.

It is possible to calculate a Julian Date using this formula:

DATEDIFF('day',DATETRUNC('year',[YourDateField] ),[ YourDateField] )+1

But it would be easier and faster for most people to have the Julian date as a date format option.