Solved

Convert current date to Julian date code - Access query or VB

Posted on 2014-04-23
2
2,490 Views
Last Modified: 2014-04-24
I need to update a field with the current Julian code on a daily basis.  The hurdle I have is how to find the Julian date code, based upon today's date.  I'd rather do it in a query, but can create a macro and do it in VB if needed.  Any suggestions?
0
Comment
Question by:dzirkelb
  • 2
2 Comments
 
LVL 57
ID: 40017544
Really simple, it's the VBA format function:

? Format$(Now(),"y")

Jim.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40017570
year and day BTW is:

? Format$(Now(),"yyy")

Jim.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now