maggielady
Technical User
I have a table that has a date field in this format: 08032005. I need to get that field in this format: yyyymmdd. Can someone help please? Thanks in advance.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
NewDate = RIGHT(OldDate,4) + LEFT(OldDate,2) + SUBSTR(OldDate,3,2)