Change text to dates in access xp

[chrisd49]

Hi All

I am building an app in access xp and the client has a set of excel spreadsheets which contain a text identifier for a time period, (ie w=weekly, m=monthly, q=quarterly etc). I know the contract start date and I need to convert this text identifier into a date. The contract start date is always in the first cell of the database.

Any help with this would be much appreciated.

ChrisD

 

[Jacob Mathai]

use Cdate.

For example: caldate and txtdate are 2 columns in a table.

Update mytbl set caldate =Cdate(txtdate)