I have sharepoint list and new list form is customized in Infopath. I have a datetime field column where I'm filling date and time. I have another single text column where I want to store time only from the value captured from above datetime column.
I'm using a rule type Action to set the value for my single text column and using substring function but I get weird format of time like T00:00:00. I want to get in the format as 12:00 AM or 11:30 PM etc.
How to format the date time and get time only in the above format