Hi there,
I have a query that returns rows a row of data everyday for around 500 clients.
The first field is the extract date. As the data is monthly cummilative I would like to set a criteria for the last day of the month...what ever month or year that may be in.
Is there a simple criteria I can enter rather than inputting about a million dates.
Thanks
I have a query that returns rows a row of data everyday for around 500 clients.
The first field is the extract date. As the data is monthly cummilative I would like to set a criteria for the last day of the month...what ever month or year that may be in.
Is there a simple criteria I can enter rather than inputting about a million dates.
Thanks