Question 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

 

[WayneRyan]

Nokia,

The date is stored internally as a floating point number ... you can't change
that.

To change how it is displayed use the Format statement.

Me.txtSomeTextBox = Format(Date, "dd/mm/yyyy")

Wayne

 

[Nokia N93]

Nokia,

The date is stored internally as a floating point number ... you can't change
that.

To change how it is displayed use the Format statement.

Me.txtSomeTextBox = Format(Date, "dd/mm/yyyy")

Wayne

I tried it but it didnt work with me

 

[DCrake]

Check the regional settings on your machine, are they US or UK?

 

[Nokia N93]

yes ,, it is US

 

[DCrake]

Then you need to change it to UK.....