gregorian date

  • Thread starter Thread starter jane cline
  • Start date Start date
how can code converting a date field to the gregorian date
Click to expand...

Which of the many, many types of "Gregorian date" do you mean?
Military, with the last digit of the year and a three-digit day; two
digit year and three digit day; four digit year and three digit day;
astronomical Gregorian date; modified astronomical Gregorian date;
....?

For the (probably most common) yyddd try

format([datefield],"yy") & format(datepart("y", [datefield]), "000")
 
Back
Top