Format field to 'Date'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rafi Kfir - 09 Nov 2004 09:22 GMT

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

Reply to this Message

Bas Cost Budde - 09 Nov 2004 11:14 GMT

> HI,
>
[quoted text clipped - 3 lines]
>
> 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.

Reply to this Message