Question Locked
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am querying a ctree database, from ms access that has dates and times stored in the Julian date format. I would like to locate a function to convert the date to the format MM/DD/YYYY. E.g 2454398 is 10/24/2007 and 4417338 is 12:16 pm. None of the formula's I have seen so far work with this date and time format.
2 replies
by winstt24 Accepted solution
Clarifications
by tony hopkinson Accepted solution
http://support.microsoft.com/kb/209922
Unless you drop really lucky first you are going to have figure out how 2544398 is the 24/10/007 if it's something as simple as that many days after the base date.
Then all you have to do is work out the difference between access's day 0 and ctree's
Bring in the date as a number add the diffrence.
Given the time example you provided though I suspect it's not that simple, number of seconds since midnight would make 12:16 43260 !
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies