Date to Julian date format - ADO DAO RDO RDS

AH HA! Now I know why two MVP's made this error.

You shouldn't be partying while trying to answer the question - a little
beer or wine can definitely change the accuracy of the answers. Of course,
sometimes a little beer or wine will generate a more creative solution.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:Op248qDEIHA.4544@TK2MSFTNGP06.phx.gbl...
> Party pooper! <g>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "John Spencer" <spencer@chpdm.edu> wrote in message
> news:uu8WtzAEIHA.4476@TK2MSFTNGP06.phx.gbl...
>>
>> The other solutions posted will fail if the date occurs in the first 99
>> days of the year.
>>
>> Format(YourDate,"YY") & Format(DatePart("y",YourDate),"000")
>>
>> Assuming that the 21st Century is 1 and the 20th Century is 0
>>
>> C = Year(Date)\100 -19 will return the century so
>>
>> Year(YourDate)\100 -19 & Format(YourDate,"YY") &
>> Format(DatePart("y",YourDate),"000")
>> --
>> John Spencer
>> Access MVP 2002-2005, 2007
>> Center for Health Program Development and Management
>> University of Maryland Baltimore County
>> .
>>
>> "mtate" <mtate@discussions.microsoft.com> wrote in message
>> news:ED897CE5-0702-413A-98DF-B3E1F61E2741@microsoft.com...
>>>I need to be able to take a date format (mm/dd/yy) entered on an Access
>>>form
>>> and convert it to a Julian date for an AS400 query. The file on the
>>> AS400 is
>>> looking for this format: 1CYYDDD. For example, 10/15/07 would be
>>> 107288.
>>>
>>> Can anyone help with this? I am using Access 2003.
>>
>>
>
>

John Spencer wrote:

>AH HA! Now I know why two MVP's made this error.
>
>You shouldn't be partying while trying to answer the question - a little
>beer or wine can definitely change the accuracy of the answers. Of course,
>sometimes a little beer or wine will generate a more creative solution.


And here I thought is was just a lack of sleep that was
responsible. Thanks for straightening me out on this subtle
issue, John.
--
Marsh

P.S. Do you have an empirically derived graph of the Bugs
per Beer ratio?

"Marshall Barton" <marshbarton@wowway.com> wrote in message
news:q3pdh39m7b494qpopnh4klbeu72ga4vm2q@4ax.com...
>
> P.S. Do you have an empirically derived graph of the Bugs
> per Beer ratio?

http://xkcd.com/323/

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)