Navigation:  Queries & Reports > Running Queries & Reports > Execute prepared SQL queries > Query Form >

 

EDL Product Supporthome

Working with Dates

Previous pageReturn to chapter overviewNext page

When you are using dates within queries to specify a time period, you have to use a certain syntax.

 

The syntax is as follows (including quotation marks):

 

'YYYY-MM-DD'

 

For example, the 23rd of April 2010 would appear as:

 

'2010-04-23'

 

You will need to use this format in all areas where the Date is entered:

 

Date-Syntax