Conversion in Query

M

Michael Feldman

I am looking to convert a Text String of 9/10/05 in a field Misc.Value1 to a
date field.
 
D

Douglas J. Steele

Assuming that represents 10 Sept, 2005, you should be able to simply use
CDate(Misc.Value1).

If it represents 09 Oct, 2005, you'll have to split it into the separate
Day, Month and Year components (using the Left, Mid and Right functions),
then plug them into the DateSerial function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Julian Date Conversion 1
To make pdf to work as word 1
How to use/create code in MS Word to calculate age? 0
Task Information Dialog Box not making duration changes to task 0
Clicking link tasks again increases duration 0
Append Crosstab Query to Existing Table 0

Top