I have a form query that combines a production date in mm/dd/yyyy format with a text field in a new text box. The problem I have is that the combined field
looks like mm/dd/yyyyABCDEFG when it needs to
look like mmyyABCDEFG. How can I do this?
No date slashes (/) and convert the mm/dd/yyyy date to mmyy.
Thank you!