Date format 1

[McFestoe]

Hi,

On a report i have a field for the current date which works with =date() and displays the date as dd/mm/yy i have tried different formats of date but i need it to be displayed as dd/mm/yyyy is this possible, and where do i look, oh it only needs to be in one field all the other date fields need to be kept as dd/mm/yy.

Thanks

 

[LNBruno]

Use the format statement:
[code}
= format(now, "mm/dd/yyyy&quot
[/code]

 

[dhookom]

Actually, if this is a control source of a text box, you must add the ()s after Now. You could also use:
=Format(Date(),"mm/dd/yyyy&quot

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[McFestoe]

Thanks for the replies, and your quick help.

It has work in a box that uses the current date but if a old date is stored in a field how do you get it to be dd/mm/yyyy format do i need to setup a input mask.

Thanks

 

[dhookom]

Do you need the text box updateable or is it just for viewing. If view only, use the same function substituting your field name for Date(). If you need to edit and the setting the FORMAT Property doesn't work, you may have to either set the input mask or change the regional settings in the control panel.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[McFestoe]

dhookom

Your a star ! did not think of the simple things always look at other things and making it hard for myself, sort it with windows regional settings. I cant belive after weeks of trying it was so simple.