I have a simple Access table and one field is a timedate stamp.
I wish to retrieve only the date value ( the value and not
a formatted date string).

ie select mydate from mytable

this just gives me for example 01/10/2003 00:00:00

how do I do a select that just gives me 01/10/2003 ?

Any help appreciated

If you are trying to get the value out of a query. do as follows

In design view on the query, click on "field" on the field that you wish to change (your date field from the table).
Click on properties on the toolbar
on the general tab opf properties, click on format.
select "Short Date" from the drop down.

You can do the same in reports and forms.

Does this help?






Sal

Unfortuantely I cannot change the field in the database to be
a shortdate because other applications write a full datetime into this field. I need an Access syntax that only retrieves
the date part of the datetime field.

As Access holds dates as double precision numbers, there is no such thing as just a date field, or just a time field.

To illustrate this, try the following in the immediate window of the VBE:

?cdbl(time())
?cdbl(Date())
?cdbl(Now())

?cdate(1345.5433)
?cdate(0.5433)
?cdate(1345.0)

So, the formatted date string is your best bet really.


Brian Skelton
Braxis Computer Services Ltd.

You can try this

Inside the design view of a query create a field and enter this

x: Format([YourDateField],"mm/dd/yyyy")

Substitute YourDateField with the name of your field.
This will create a field with the title of "x" that only has the date you need.

Then if you where looking in the query for all entries with the date of today do this
under the criteria

#11/18/2003#

Does this help?



Sal

Hi sal,

yep that does it fine
Many thanks

Chas.