Date Conversion Question?

[#1]

I have a julian like numeric date i need converted.  In this date, today (January 13, 2012) is 1120113.  I've tried the code below from looking at other sources, but it doesn't work.

date(date#(mrsdtc, '1YYMMDD'), 'DD-MM-20YY') as "MO Date",

Any thoughts?

[Miguel_Angel_Baeyens · Accepted solution]

Hi Brandon,

You may get rid of that leading "1" in the Date#() and set the Date() to display 'DD-MM-YYYY' instead:

Date(Date#(Right(mrsdtc, 6), 'YYMMDD'), 'DD-MM-YYYY') AS "MO Date"

Hope that helps.

Miguel