Hello Ernesto, thank you for your reply. Making them text strings does not meet my business requirement. I have actually somewhat tried that using substring function and formatting accordingly, however as I mentioned, when I submit to SharePoint the date and time formats default back.