| | |
|
|
|
gregorian date |
|---|
| message from jane cline on 4 Jun 2004 |
how can code converting a date field to the gregorian date
|
| John Vinson replied to jane cline on 04 Jun 2004 |
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")
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: gregorian date (MS Access Forms)
