B bugsy Registered User. Local time Yesterday, 22:31 Joined Oct 1, 2007 Messages 99 Nov 13, 2007 #1 Hey. How do I format Date field in query grid to make field into "11/11/2007" if the data originally has time, or in form "11 Nov, 2007" ?
Hey. How do I format Date field in query grid to make field into "11/11/2007" if the data originally has time, or in form "11 Nov, 2007" ?
boblarson Smeghead Local time Yesterday, 22:31 Joined Jan 12, 2001 Messages 32,040 Nov 13, 2007 #2 MyNewDate:Format([YourDateFieldHere],"m/d/yyyy")
B bugsy Registered User. Local time Yesterday, 22:31 Joined Oct 1, 2007 Messages 99 Nov 13, 2007 #3 thanks ! (mm/dd/yyyy) is even better