Hello, Daylon, can you share how you did this. I need to accomplish the same task in a New job we are creating and this is throwing me for a loop. ... View more

Using the "Having" instead of "Where" appears to have done the trick. Although, it wouldn't work without using the "Group By" too. I still feel like I'm not going about this particular job in the most efficient way, I'm learning a lot as I go. ... View more

First off, you've all been amazing!  I'm currently in the process of rebuilding our entire Bank's reporting system and I clearly have lots of questions.  To my defense though, the "LAST_DAY" function does appear in my list of available functions, and intuitvely that has been what I've been trying so desperately to make work for this particular situation.  In our current reporting environment (Oracle), I use a similar function for this particular custom field, and I think that's also why I was trying to use that one instead of INTNX.  Either way, THANK YOU ALL!!!!! ... View more

The problem was that I wasn't putting ' ' around the 0, which since zero is a numeric value then I didn't think that it was required but your explanation as to why it has to be, makes perfect sense.  Thank you LinusH!! ... View more

Ok, it's for sure solved this time.  Keeping it in a Numeric type and using the expression:   OutDate = INPUT(InDate , yymmdd10.)   AND A Format of "mmddyy10."   Whew!  Thank you both! ... View more