G Guest May 13, 2005 #1 How does one convert the date 12131946 to 19461213 without losing any information?
R Rick Brandt May 13, 2005 #3 PaulaV said: How does one convert the date 12131946 to 19461213 without losing any information? Click to expand... If it's a character string... =Right([StringOrField], 4) & Left([StringOrField],4)
PaulaV said: How does one convert the date 12131946 to 19461213 without losing any information? Click to expand... If it's a character string... =Right([StringOrField], 4) & Left([StringOrField],4)
D Douglas J. Steele May 13, 2005 #4 I'd definitely use & rather than + to concatenate the values, just to make sure it does concatenate and not add the numeric values.
I'd definitely use & rather than + to concatenate the values, just to make sure it does concatenate and not add the numeric values.
