topic Re: Filtering on julian date in QlikView

Filtering on julian date

Fri, 05 Aug 2016 10:44:52 GMT

Hi I have the following date field in julian format:

Sales_Date

40592

40622

40584

40602

40565

Have loaded in the field as

Date(Sales_Date,'MM/DD/YYYY') as Sales_Date_New

My question is how would I then write out a where clause to filter the date on any particular year given the original date format is in Julian standard ?

Re: Filtering on julian date

Gysbert_Wassenaar — Fri, 05 Aug 2016 10:51:48 GMT

Same as with any other date. A Julian date has the same format. It's just not the same day as the Gregorian date value. If you're asking how to calculate Julian dates from Gregorian dates then look at this blog post: Non-Gregorian calendars

Re: Filtering on julian date

Fri, 05 Aug 2016 10:59:22 GMT

Thanks. So are you saying it'd be literally something like

WHERE Sales_Date > '01/01/2014'

to exclude any dates before 2014 ?