I am trying to write a DB query to pull data based on a field value between two datetimes. I’m pulling the criteria datetime values from two datetime tags. I keep getting errors and can’t seem to hit the right combination of delimiters to identify the tag values as dates. See below:
[attachment=1]Screen Shot 05-09-14 at 08.17 AM.PNG[/attachment]
And another attempt:
[attachment=0]Screen Shot 05-09-14 at 08.19 AM.PNG[/attachment]
Any insight into the proper syntax or otherwise what I’m missing would be greatly appreciated.