string to date

[wdbouk]

Hi,

i am wondering how to update columns with dates like 8/20/1991 to date number like 33470
thx

 

[Golom]

Not sure what you're asking. DateTime fields are already stored as numbers. The "8/20/1991" form is only a formatting thing. If you want to see the number in a query then

cDbl(DateTimeField)

should give it to you.

 

[wdbouk]

UPDATE Prices SET cDbl(Date); I am receiving a syntax error. i want my dates in teh date column to be in a number format and not the mm/dd/year format

 

[Golom]

First of all, that's an invalid statement. An update statement has the form

UPDATE myTable SET fld = Value

You're missing the " = Value" part.

Second ... as I said ... Access wants to present DateTime fields in some DateTime format such as "8/20/1991". Those values are already in the database as numbers. You are attempting to change the formatting by changing the stored value. You need to make the change where the data is presented ... not how it is stored. For example

Select cDbl(DateTimeField) As DateNumber
From myTable

Should display the numeric value for the date.

 

[PHV]

Simply use # as display format.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886