Convert odd number to date

  • Thread starter Thread starter Sabosis
  • Start date Start date
S

Sabosis

Hello-

I have a report that I ran from our AS400, and the date fields are
coming out strange. I have a string of 109031 that I can cross
reference to see that the "09" is the year, and "031" is the day of
the year. All of the numbers in these fields start with a 1, but it
does not seem to signify anything. 108366 would mean 12/31/2008, etc.
Any ideas on a formula to get these columns to display a regular
calendar date?
 

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

formatting odd date field in table 1
converting text to proper dates 6
Totals by Year 3
formula to count matching days between two date ranges (for largelist of names) 2
week numbers 3
Problem with Excel Dates 11
Max Value in Year 3
Date formatting 4

Back
Top