Hi. I'm having a problem. I'm trying to append my date column to this other column. I specified that it be in yyyymmdd and this works but when i click on the cell it reverts to a dd/mm/yyyy format. When I unfocus the cell it goes back to the yyyymmdd.
The problem comes when i run an update query to append the date to the other string. When I do this it
uses dd/mm/yyyy even though i want it to use yyyymmdd. Is there a way to format the fields I use in the update query? Thanks in advance for any help.
The problem comes when i run an update query to append the date to the other string. When I do this it
uses dd/mm/yyyy even though i want it to use yyyymmdd. Is there a way to format the fields I use in the update query? Thanks in advance for any help.