Are you able to make a connection to sql database via Qlikview?
If so you can still use your sql script:
where [Group] ='Help Desk'
AND MONTH(SnapDate) = 3
AND YEAR(SnapDate) = 2012
AND ((cast(SnapDate AS DateTime) - cast(isnull([Create Date],'') AS DateTime) >0))
AND (((cast(SnapDate AS DateTime) - cast(isnull([Resolved Date/Time],'') AS DateTime) <1))
OR isnull([Resolved Date/Time],'')='')
Thanks for the suggestion Frank however there are quite a few other things happening in the load script to bring the expression as is. I will keep it in mind though. I'm however now thinking that I might have to modify my SQL query and use something like datediff to calculate the difference in days between the dates and then try to match that up in QV. Still working on it.