bopo
01-11-2008, 02:29 AM
Hi
Right I have a varible which stores a date (dd/mm/yyyy) as a string, what I want to do is extract the (mm) from the date and store it in another varible. I have looked at some Access string manipulation functions but I have only found ones that measure the length of the text.
If possible, I would like a function which allows me to specify a start and stop point(as I only want mm), but anything that will work is fine :thumb
Right I have a varible which stores a date (dd/mm/yyyy) as a string, what I want to do is extract the (mm) from the date and store it in another varible. I have looked at some Access string manipulation functions but I have only found ones that measure the length of the text.
If possible, I would like a function which allows me to specify a start and stop point(as I only want mm), but anything that will work is fine :thumb