I am sourcing data from excel that I need to paste into a date field on a webpage. I set up a display message box to see how the data was porting and realized the date values are porting over with a time-slot. For example; I have “3/17/2021” listed in excel, but it’s coming over as “3/17/2021 12:00:00 AM”...which is preventing me from pasting. How can I remove the time-slot?
Hello @jfkbbb ,
Please use "Convert Datetime to Text" and select format as "Short date" under Standard as shown here:
This action helps in retrieving only Date and not the time.
Thanks and hope it can help you.
Did I answer your question? Please consider to Mark my post as a solution! to guide others
Check out how to claim yours today!
Check out new user group experience and if you are a leader please create your group
Test your skills now with the Cloud Skill Challenge.