Selecting a portion of a field between two delimeters 1

[bravo6]

I have a field that has the format 2/1/2008 or, depending on the month and day, it could be 10/13/2008. I want my query to select only what is between the slashes and always return a 2 digit (zero filled) number. So 2/1/2008 should return "01" and 10/13/2008 should return "13"

Thanks and thanks to everyone that helped me yesterday

 

[lespaul]

in the table is it a date field or a text field formatted to LOOK like a date?

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[bravo6]

I beleive it is a date field

 

[PHV]

Format(yourDateField, "dd")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886