I have a field containing date and time. If I want to run a query against the data just showing todays date I get no records returned because of the time data. Doing some research on the net I found the solution should be to make a query that adds a calculated field that formats the data to dd/mm/yy and then query that calculated field.
Could not get this to work in ASPRunner so I added the query to the database and in ASPRunner SQL editor mode run the results and it works fine. However when I build the DB it returns no records. Any suggestions?