converting a number to a Julian Date

L

LisaK

I am trying to take part of a claim number that is a Julian Date and
translate it into a calendar date. Any suggestions on what to use in my
query. Here are some examples of the 4 digit numbers:

9248
9230
9342
9345

Thank you - Lisa
 
D

Douglas J. Steele

There are actually several different definitions of Julian Date. Which one
are you trying to use? (In other words, to what should those four sample
values equate?)
 
J

John W. Vinson

I am trying to take part of a claim number that is a Julian Date and
translate it into a calendar date. Any suggestions on what to use in my
query. Here are some examples of the 4 digit numbers:

9248
9230
9342
9345

Thank you - Lisa
Click to expand...

I presume the 9 means 2009 (or 1999 or 2019 depending on the context)? What's
the datatype of this field: text or number (either will work but numbers don't
have leading zeroes)? Will these dates always be in the past (to resolve the
which-decade ambiguity)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get the date to display a Julian date? (yyddd) 2
converting julian Date to Database date 5
Calculating a Julian Date 7
Pulling a date from a two digit year and julian date 3
Converting Date to Julian 4
Strange Julian Date Phenomenon 9
How to Convert a Julian Date to Calendar Date 2
Need to convert Julian Day to Gregorian date 8

Top