concatenate dates into one string

[csdk1207]

Hii guys,

Need some help writing a VBA script for an access form. Please do help me out.
Here s what I have:

A access form that gives the start date(StrDate) and enddate(EndDate) for reporting.
I need to query the data base for records between these two dates but here is the catch.

The coulumn Month ( which I would like to query between StrDate and EndDate) is not in the date format.
It is in Text and has values such as "Q1 2006" or "2006-01-Jan" where 01 represents the month and not date.
So the month of February would be represented as "2006-02-Feb".
If the date was in the form Q1 then I know that I need to resolve the start date to "2006-01-Jan"

So This is what I would like to do :

write a function that takes the two dates, and concatenate all month in between as one string.
For example if the two dates are Q1 2006 and Q2 2006. The dates in between would be
"2006-01-Jan" , "2006-02-Feb", "2006-03-Mar" , "2006-4-Apr", "2006-5-May" and "2006-6-Jun"


How do i do this ?
Thank you guys for reading through this complex description.

[jindon]

Example

Please Login or Register  to view this content.