Can i change the format of DATE () ?

[Nokia N93]

the date is appearing 11/27/2010
is this the default in Ms. ACCESS??


how can i change it to 27/11/2010
p.s I used the date() to be entered automatically after updating a textbox ,, i want to change it to 27/11/2010

[ajetrumpet]

default formatting of dates depends, initially, on the distribution version you have. you may be able to set the default format in the options, but to change in the program, use format():

format(date(), "mm/dd/yyyy")

or something similar. the help file on the function tells it all.

[skahle89]

You can use the "Format" property of the control if this is on a form. Date-Times are stored as a serial number regardless of what input mask or format you use; specifying a Format just tells Access how to display the date. Click in the Format property for the text box in question and press F1 if you need more help.