Convert to Julian Date and add leading zeros in one query

[JustATheory]

When converting to the Julian date I need it to be in a three digit format with leading zeros. I need it to be in a field not a report as this data is passed to a vendor in a file and that is the requirements. I'd like to do it in one query, if possible. The below query gives me the correct Julian date, I've tried adding ,"000" to the function with no luck. Any help is appreciated.

SELECT date.Date, Format([date],"y&quot AS Julian
FROM [date];

 

[nealvenables]

Hi,

Did you try embedding one format statement within another? e.g.

Format(Format([Date],"y"),"000")

 

[JustATheory]

Perfect! Thanks!