In FlySpeed Query when entering dates for an MSSQL 2008R2 database can a user enter UK format dates as criteria rather than US format dates?
ie: US users will wish to query the database with a US date format but UK users of the same database will wish to query using UK dates. Is this possible? Is there some form of client date format that can be set?
Ideally this is a set once and forget option rather than something they need to run every time.
NB. I've got the output displaying in UK format it is just that the criteria appears to have to be in US format and this will play havoc with the productivity of UK users if they have to remember to convert to US dates for every query.
We will impement a tree-like criteria builder that will let enter dates in appropriate editing control.