Thanks for the prompt response: This is my formula.
cdate(Trim (Left ({time.Work_Date},2 ))&"/"&Trim (right (trim(left({time.Work_Date},4)),2 ))&"/"&Trim (right ({time.Work_Date},2 )))
This is the formula that I have... a little different than yours, but I still get the same result
My...
Hi
I have a string in that represents a date in the following format "ddmmyy" I need to converted into its correponding date, but I havent been able to do it either by using Cdate or DTStoDate
Any ideas..
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.