Excel SQL Connection if parameter is blank

[Dmcnich15]

Hello-

Here is my setup. I have a data connection in Excel that runs a SQL query. There are 2 parameters, year and month, that point to cells in excel. I would like if month is left blank to pull everything for the year.

For instance

If year = 2017 and month = 12 pull december of 2017
If year = 2017 and the cell for month is blank pull all of 2017


Im not sure if this is possible but if so what would be the best way to use it? I tried adding a case statement in my SQL for isnull but that isnt translating to excel

 

[jjasmith4]

Something like this should work:
SELECT fields FROM table WHERE YEAR(datefield) = [year param] AND ([month param] = 0 or [month cell] IS NULL or MONTH(datefield) = [month param]