Recent content by bgraybea

To answer your question, I'm querying a data table that someone else provides, so the date is coming to me in a YYYYMMDD number format. I did figure out how to get the answer I was after, and it was much simpler than I thought after sort of going a different route...here's the successful...

I'm new to the forums and am hoping someone can help. I have date data stored in a table as 8 digits YYYYMMDD. I basically need to group data by month using a mid-month cutoff - for example, everything between 20101016 and 20101115 would be grouped as 201011. I've written the following as a...