If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
gregorian date
how can code converting a date field to the gregorian date
|
#2
|
|||
|
|||
gregorian date
On Fri, 4 Jun 2004 10:46:58 -0700, "jane cline"
wrote: how can code converting a date field to the gregorian date 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 |
Thread Tools | |
Display Modes | |
|
|