I have an Excel/VBA UserForm that accepts the date that a record is created (manual entry ito a textbox or via click of a command button which fills the textbox with the system date from the Date() function.) I've used a temporary mgsbox, formatting the output to confirm that the correct date is being set:
Code:
Me!DateBookingMade = Format(Date, "dd/mm/yyyy")
MsgBox (Format(Me!DateBookingMade, "dd/mmm/yyyy"))