Text to Date field in Access

[rhonda6373]

I am trying to subtract 2 dates in Access, however they are currently in text fields and I cannot subtract. Is there any way to change them to a date field?

[Seth Schrock]

So are you trying to find out how many days are between those two dates? If so, then you would use the DateDiff() function. You would then have an unbound textbox that uses this as it default value. Here is more information about the DateDiff() function: Calculate the difference between two date or time values
If you are looking to add a certain about of time to a date, then you would use the DateAdd() function. MS Access: DateAdd Function

[zmbd]

rhonda6373:
You have not provided enough information.
Where are the fields located?
What format is the date in?
Where are you trying to do the calculation?
-z

[NeoPa]

Yes Rhonda. The CDate() function will do that for you.