Skip to Content
0
Former Member
Jul 31, 2014 at 05:39 PM

Creating a Date Variable

18 Views

Hello,

I'm trying to query for a range of dates Month, Year to Month, Year

As you can see, the current format of my tables are that [month] = # (1 is January, 2 is February, etc) and [year] in two separate fields.

How do I create a variable where it takes both month and year fields into a useable date format where I can query a range of months.

For example, if I want to query October 2013 - March 2014, the fields for [month] and [year] would be 10,2013; 11,2013; 12,2013; 1,2014; 2,2014; 3,2014

Attachments

2.PNG (14.3 kB)