Format NOW() function

[Alhousani]

Hi,
In my database I have feild for date and the default value of it is taken from know function so the date in the feild is showing 22-feb-08 21:55 but I want it to be in dd-mm-yy hh:mm. I tried to used this format in the table but whenever I click on the feild the date shows in 22-feb-08 21:55 format so how I can keep it as dd-mm-yy hh:mm perminent.

 

[GolferGuy]

Look up the Format function in Access help, and in Access VBA help (from the VBA editor).
This: format(Now(), "dd-mmm-yy hh:nn") gives: 22-Feb-08 09:57
and
this: format(Now(), "dd-mm-yy hh:nn") gives: 22-02-08 09:57

 

[Brianwarnock]

Check the default short date option in your Windows settings.

Brian

 

[Alhousani]

Whenever i used any type of format, (Now(), "dd-mmm-yy hh:nn") or format(Now(), "dd-mm-yy hh:nn") the result is 22-Feb-08 09:57 but I want it to be 22-02-08 09:57.

If anyone can help me with example db it will be great.

 

[Brianwarnock]

You say that it shows 22-feb-08 21:55 when you click in the field, this suggesrs that it shows as 22-02-08 21:55 when the cursor is not in the field.
This is a result of your date default in windows as I said earlier.

Brian