Convert seconds to Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that is in seconds only. This field needs to be converted to
a date format. How do I do this?
 
Not sure what you mean. Seconds in the field now? 10, 50, 1000? How would
we convert that to a date?

You'd have to give us some examples of how "seconds" could be turned into a
date.

Rick B
 
Tess said:
I have a field that is in seconds only. This field needs to be converted to
a date format. How do I do this?
Click to expand...


Wow, is this vague or what?

What is the seconds value based on???

Do you want it in time of day? Is the seconds value a
duration you want converted to hours and minutes?? Is it a
Unix type date based on the number of second since 1/1/70??
 
Sorry, it's a "Unix type date based on the number of second since 1/1/70". I
need converted into a subtype 7 date.
 
Ok, so now the question for me is what is a Subtype 7 date?

In Access you could convert this with the dateadd function

DateAdd("s",NumberOfSeconds,#1/1/1970#)

That will give you a date and time which you can format (as a string) in
whatever way you wish.
 
Back
Top