converting a number to a Julian Date

  • Thread starter Thread starter LisaK
  • Start date Start 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
 
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?)
 
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)?
 
Back
Top