hi
got a field that is a long string of information with spaces to separate different bits of information that include a date in simple ddmmyy no slashes or dots
I'm using various left and instr functions to separate out the information into individual fields in a query
all working other than I can't get the date to show as a date
Expr5: Format$(Left([expr4],InStr([expr4],"-")-2),"dd/mm/yy")
example
161220 I want to have as date value 16/12/20 but instead I am getting 27/05/41 ??
what am I missing ?
thanks in advance for any help
got a field that is a long string of information with spaces to separate different bits of information that include a date in simple ddmmyy no slashes or dots
I'm using various left and instr functions to separate out the information into individual fields in a query
all working other than I can't get the date to show as a date
Expr5: Format$(Left([expr4],InStr([expr4],"-")-2),"dd/mm/yy")
example
161220 I want to have as date value 16/12/20 but instead I am getting 27/05/41 ??
what am I missing ?
thanks in advance for any help