In an access database the field "date1" is a text datatype that is formatted as "yyyy-mm-dd hh:mm:ss"
How do i shorten this to display only "mm-dd"?
I'm getting the left side but i need it to cut off.
LEFT({Anaheim_Import_Data.Incident_Date},6)
How do I convert this to "mm-dd-yyyy"?
How do i shorten this to display only "mm-dd"?
I'm getting the left side but i need it to cut off.
LEFT({Anaheim_Import_Data.Incident_Date},6)
How do I convert this to "mm-dd-yyyy"?