How can I extract date from a short text(length 27) Temp= 2020-01-22 00:00:00.000000 to Dt_Tested=1/22/2020
I have to update all the records in my table.
Thank you
How can I extract date from a short text(length 27) Temp= 2020-01-22 00:00:00.000000 to Dt_Tested=1/22/2020
I have to update all the records in my table.
Thank you
Maybe:
CDate(Left(string, 10))
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
get date:
=mid([field],6,2) & "/" & mid([field],9,2) & "/" & left([field],4)
It worked. Thank you