Forum Discussion
date convertion (s)
need help converting a date formatted 20230117093739 YYYYMMDDHHMMSS to 01/17/2023 (in one cell) 9:37:39 AM (in the next cell). i normally use this mid string Date: Mid([INB_DATE_TIME],5,2) & "/" & ...
Hi,
With the string functions you create a string. If you want to compare it with a date, you have to convert it to a date:
NewDate: cdate(Mid([INB_DATE_TIME],5,2) & "/" & Mid([INB_DATE_TIME],7,2) & "/" & Mid([INB_DATE_TIME],1,4))
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon