Extract date as date from date and time stamp
I am importing a date and time stamp (e.g., 9/3/2022 8:36:19 AM) and need to extract the date into a date field so Smartsheet recognizes the date. I have a formula to extract the date as text (i.e., 9/3/2022) in another column, but cannot find a formula that works to convert the month and day to two digits and converts the date to the format that is recognized by Smartsheet. Your help is appreciated!
Help Article Resources
Check out the Formula Handbook template!