Article ID: 92816 - View products that this article applies to.
This article was previously published under Q92816
Moderate: Requires basic macro, coding, and interoperability skills.
Most government agencies and contractors require the use of Julian dates. A Julian date starts with a two-digit year, and then counts the number of days from January 1. Microsoft Access does not have any built-in functions for using or converting Julian dates to standard dates. However, you can write a function to do this. This article demonstrates a sample user- defined function that converts a Julian date to a standard serial date. Note that the following sample code assumes the year is in the 20th century. The code must be changed to process dates after the year 2000.
This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to your version of the "Building Applications with Microsoft Access" manual.
NOTE: Visual Basic for Applications is called Access Basic in Microsoft Access versions 1.x and 2.0. For more information about Access Basic, please refer to the "Introduction to Programming" manual in Microsoft Access version 1.x or the "Building Applications" manual in Microsoft Access version 2.0.
You can use the following sample function, ConvertJulian(), to convert Julian dates to standard dates.
NOTE: In the following sample code, an underscore (_) is used as a line- continuation character. Remove the underscore from the end of the line when re-creating this code in Access Basic.
Examples of How to Use the ConvertJulian() FunctionExample 1:
Article ID: 92816 - Last Review: January 18, 2007 - Revision: 2.3