Specification of dates

The format for dates is a string written as follows: DD/MM/YYYY. For example, a valid Alfabet query condition would be Application.Startdate = ’27/09/2005’.

The majority of date properties can be written like this, but there are a few system properties that save not only the date, but an actual timestamp that records the date and the time in milliseconds.

In the example Application.CREATION_DATE = ’27/09/2005’, it is likely that nothing will be returned even though it is a valid condition. But because every creation date is stored as a timestamp, it will only return applications that were created on the 27th of September in the year 2005 at exactly 12:00:00.000 pm (which is highly unlikely). However, you could theoretically write a condition like Application.CREATION_DATE = ’27/09/2005 09:13:04.568 am’, if you know the exact timestamp when the application you seek was created. Alternatively, you can find applications created on a specific date with a WHERE condition using a BETWEEN operator, for example Application.CREATION_DATE BETWEEN ’26/09/2005’ AND ’28/09/2005’.