Filtering on julian date

[#1]

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 ?

[Gysbert_Wassenaar]

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

[#3]

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

WHERE Sales_Date > '01/01/2014'

to exclude any dates before 2014 ?