Changing the format of Date input in Access Query fro calculation

[Salesh Dayal]

My query requires a date input however when this date is outputted, it comes in a format DD/MM/YYYY however the display format is still text and not a date. i want an extension of the query (calculation purpose) using this field however it is not possible using this format.

The input request is as follows:
PayDate: FormatDateTime([Enter Pay Date],0)

[Mihail]

I think that a look to this article may help you.

http://bytes.com/topic/access/answers/925663-discussion-sql-date-literals-regional-settings

[NeoPa]

I think what you need is to pass the value as-is (A date I presume) but use the Format property of the control or field to display it as required, rather than a function which returns a string. Both ways show the date correctly formatted, but only the former allows the data to be treated as a date going forward.