Good day to all!

I have a Date Field called LabInspectionVisitDate it's format is set as "yyyy/mm/dd".

This date is used in a letter template. I want the letter to provide a period after the date object, and I want that period to appear naturally (label just did not look natural to me).

So....in an unbound text box I have =IIf(IsNull([LabInspectionVisitDate]),"",[LabInspectionVisitDate] & ".")

This gives me a very nice looking date with a period that looks like it was typed. HOWEVER....for some reason Access is changing the date format from the default of "yyyy/mm/dd" to "m/dd/yyyy"

How can I keep my international date format while using the =IIf(IsNull...?

Thank you in advance.

=IIf(IsNull([LabInspectionVisitDate]),"",format([LabInspectionVisitDate],"yyyy/mm/dd") & ".")

??

Perfect ! thanks! :o