hello all. I am currently trying to convert entries in the mm/dd/yyyy format into a yyyymmdd format. I am using the following expressions in an update query.
=Right([oldDate],4) & ....
I don't know what to do next because some dates have only a single digit for the month and/or day. I was going to use if statements to grab just one digit from the left if the digit is less than 10 but do you know how i would go about this?
Or could someone just show me the expression(s) i would need to convert a date in the mm/dd/yyyy format into a yyyymmdd format using string manipulation text?
=Right([oldDate],4) & ....
I don't know what to do next because some dates have only a single digit for the month and/or day. I was going to use if statements to grab just one digit from the left if the digit is less than 10 but do you know how i would go about this?
Or could someone just show me the expression(s) i would need to convert a date in the mm/dd/yyyy format into a yyyymmdd format using string manipulation text?