julian

  • Thread starter Thread starter Michael S. Montoya
  • Start date Start date
M

Michael S. Montoya

I have a date coming in from another source which is in Julian format. How
can this date be displayed as short date on forms/reports.

Thanks
 
I have a date coming in from another source which is in Julian format. How
can this date be displayed as short date on forms/reports.

Thanks
Click to expand...

Which of the dozens of date formats called "Julian" is this? the
military last digit of the year - day of the year? Two last digits of
the year - day of the year? Astronomical Julian date? Modified
Astronomical Julian date? Ides and Calends <g>?

GUESSING that it's 2004196 for today, you can use

DateSerial(Left([JDate], 4), 1, Right([JDate], 3))
 
Back
Top