By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,086 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,086 IT Pros & Developers. It's quick & easy.

Format field to 'Date'

P: n/a
HI,

1) I'm using a program that save data automatically into a database.
I'm using access to view the data using queries. In the 'StartDate'
field the data appears as a number (e.g. 38299.6143981482).

What can I do in order to view this data as TIME/DATE?

2) In another field that data is in seconds. How can I format it to
show HH:MM:SS ?
Thanks
Rafi
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Rafi Kfir wrote:
HI,

1) I'm using a program that save data automatically into a database.
I'm using access to view the data using queries. In the 'StartDate'
field the data appears as a number (e.g. 38299.6143981482).

What can I do in order to view this data as TIME/DATE?
I'd say (in the query design) choose that column, view properties,
choose Long Date as format. Or, use a custom format string.
2) In another field that data is in seconds. How can I format it to
show HH:MM:SS ?


First, divide by 86400 (the number of seconds in one day). Then, format
as above.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.