@basic_sas wrote: Huh, well I have the query working when I just put in the dates that way with no macro variables. Otherwise, it can't find these numerical values for dates. You're likely using SQL Pass through then, but nothing in your code or post would have allowed us to know this ahead of time.  If that is the case, you wouldn't actually be putting the dates as is, it would be in quotes, which you still need to do. I'm not sure if it needs single or double quotes, but it needs one and no d at the end.     ... View more