I have a query to get a specific date range, the problem is that the date is stored in the database like this:
February 7, 2014 4:27:32 PM EST
when I do my query like this:
select State, Priority, id, Headline, Submit_Date
where Assigned_To = 'Misty Phillippi'
and id like '%049%' and (Submit_Date >= '01/01/2014'
and Submit_Date <= '02/15/2014')
I know that I have a record with my query criteria but it is not giving me that result because of the date
State Priority id headline Submit_Date
In_Progress 2-Give High Attention ent00093049 Clear and Simple Letters to be built Post Go Live February 7, 2014
4:27:32 PM EST
I am not sure how to make the date changed to pull that record.