Is there a way to combine/transform a Date&Time column into Domo?
So I've built a data set in another program, Midas, that I created a workbench job for and pulled it onto Domo. It has columns such as "IP Start Date" and "IP Start Time" and similar for discharge times etc. An end user is wanting to see patients broke down by Admit date, military time, and specific length of stay like "1.6" days etc.
So I was thinking of doing a date difference calculation for current date/time - the combined columns of IP start date and time. The problem I am encountering is that from Midas the start date/time is in the form of "MM/DD/YYYY" and time is military like "1706". However once the data goes through the workbench it shows in Domo for it's column in the following format "YYYY-MM-DD" and date changes to "2022-11-09T11:46:00-05:00".
Is there a way to transform the DOMO day/date format to match how it comes out of Midas and then use a date diff fxn or similar to achieve the format I mention above of "Admit Date, Admit Time via Military Time, Specific length of stay" in a table card or similar.