Converting Julian Date to Standard

[jjake]

Hi all,

I am using this expression I located to display a purchase order # as the current date it was input and the record number that was entered that day.

=Year(DateAdd("m",3,[OrderDate])) & Format([OrderDate],"yyy") & Format([OrderID],"0")

How do I convert it so that it does not display in Julian Date, and instead uses the standard calendar (Gregorian?)

 

[llkhoutx]

A date is a date is a date. It ccan be displayed in whatever Format you want, regardless of how it's displayed. Note that Format is the operative function.