Full Version: Date Not Formatting
UtterAccess Forums > Microsoft® Access > Access Forms
M2C
Hi
I am using this code
CODE
ResponseStr1 = MsgBox("Would you like to view the agenda for " & vbCrLf & vbCrLf & Format(Me.[SessTmFrm], "ddd dd mmm yyyy") & "?", vbYesNoCancel, "Message")

However the date is coming back as
Sat 30 Dec 1899
When it should say
Mon 17 Oct 2011
thanks
Chris
M2C
Apologies: I was using a time field pullhair.gif
How sorted
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.