Date formatting

[jadd]

It was all good until we started to replace our old computers with new ones.

I have some reports that pull the dates from an unbounded text box on a form (formatted mm/dd/yy).

The regional settings on the old computers had a short date format of mm/dd/yy. Of course, the new computers have a regional setting of mm/dd/yyyy. On the form the date appears correct, but on the report it shows the mm/dd/yyyy format.

Is there a way to change the following expression to make the control source of the text box on the report display the mm/dd/yy format?

="For the period from " & [Forms]![frmLookupDevFeeBillingRpt]![BeginningDate] & " to " & [Forms]![frmLookupDevFeeBillingRpt]![EndingDate]

Thanks in advance

Jadd

 

[simongallop]

="For the period from " & format([Forms]![frmLookupDevFeeBillingRpt]![BeginningDate
],"mm/dd/yy") & " to " & format([Forms]![frmLookupDevFeeBillingRpt]![EndingDate],"mm/dd/yy")

 

[jadd]

That's what I was looking for Harry! Thanks! I learned something new.