when trying to take a date from an excel file no matter what the format in excel is will move to EP as
2020/01/01 06:00:00 /0600
I am trying to convert it to mm/dd/yyyy and not having much luck. Any help would be appreciated.
here is some code I am using;
//Converting DOB for Epic
put patient.age into ptdob
replace “-” with “/” in ptdob
log ptdob
put characters 1 to 4 of ptdob into year
put characters 5 to 6 of ptdob into month
put characters 7 to 8 of ptdob into day
put “& month & “/” & day & “/” & year &” into ptdob
log ptdob