Convert date to Julian

Miguel A. Velez

Guest

Posts: n/a

12-12-2003, 12:05 AM

>-----Original Message-----
>Is there a way to convert an Access short date format
mm/dd/yyyy to Julian date format?
>.
>

You can try this:

DateJulian = DateDiff("y", DateSerial(Year(DateVal), 1,
1), DateVal) + 1 + Year(DateVal) * 1000

where "DateVal" is the Access short date you want to
convert and "DateJulian" is the numeric field to which you
want to assign the Julian date.

Miguel.

« Re: I'm prompted for parameter value when I don't expect it | hello »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Julian Date Format (1,2,3...364, 365) for MS Project 2003	ajearl2	Project Newsgroup	2	04-04-2007 02:56 AM
Convert Date given by outlook api to java date	amit deshpande	Outlook Newsgroup	0	06-26-2006 02:24 PM
VBA-Convert Julian Dates	PSKelligan	PowerPoint Newsgroup	2	04-29-2005 02:20 PM
julian date	nkob	Access Newsgroup	3	08-24-2003 09:57 PM
convert date to julian date	Bon	Access Newsgroup	1	07-03-2003 04:42 PM

All times are GMT. The time now is 02:35 PM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.