Simple Date Format Question

[KB via AccessMonster.com]

I have a field that is displayed on a form that is just for the user and
doesnt link to a field on a table and have formated a cell as:

=Switch([Date Closed] Is Not Null,("CLOSED" & Date()),[Date Opened] Is Not
Null,("OPEN" & Date()))

The problem is the size of the display area (which if made larger wont be
aligned with the rest of the form) and the display comes up with the last two
digits of the year cut of ex: CLOSED 10/22/20..

I want to format the date as dd/mm/yy, any suggestions

 

[John W. Vinson]

I want to format the date as dd/mm/yy, any suggestions

So do:

=Switch([Date Closed] Is Not Null,("CLOSED" & Format(Date(), "dd/mm/yy")),
[Date Opened] Is Not Null,("OPEN" & Format(Date(), "dd/mm/yy")))

 

[Beetle]

=Switch([Date Closed] Is Not Null,("CLOSED" & Format(Date(),
"dd/mm/yy"),[Date Opened] Is Not Null,("OPEN" & Format(Date(), "dd/mm/yy"))