extract date from string

[laffeg]

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

 

[Minty]

Check out the date serial function - something like

DateSerial(Mid([YourField]5,2),Mid([YourField],3,2),Left([YourField],2))

DateSerial Function - Microsoft Support

support.microsoft.com

 

[laffeg]

excellent - gold star to you !
works a treat
many thanks

 

[Gasman]

? cdate(161220)
27/05/2341

 

[Gasman]

Not a correction Pat, just showing it was not even 2041