how can I display the date from a number of seconds given?

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

Guest

As the expression: =Format(Now(), "y") displays the number of the day of the
year the current date represents, where y is 1 through 366.... I need the
antonym funtion of this, in order to get a date from a specific number of
seconds given.
Could somebody help me on this matter?
Thanks in advance for your help
 
A date from a number of seconds given? Huh?

If I tell you "120 seconds", what date would you expect to see?

I don't understand the question.
 
Aha! sounds like you want to know the number of seconds from the beginning
of the year. It seems to me that there are 86,400 seconds in a day, so take
whatever they give you and divide by 86,400. That will give you the number
of days. I am still not sure how to return a DATE though. Since I am not
sure where your starting point would be.
 

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

Want the week number of a given date 5
Another most-recent date query 0
Creating a "grid" of data 3
Days in part of the month 1
Concatenate Date and Number field for Append Query 0
Totalling records in a given date range 3
Query to Count Duplicate Values in a Given Date Range 5
Divide a a range of dates into intervals starting with the current date or the latest date in the ra 2

Back
Top