I was extracting datasets with mixed data types (real number, dates and time etc) to excel format. It is a single site study and I was extracting data from one CRF of an event. In my exported dataset only real number showed up, and data that was stored in dates / time formats went missing. I then went on to extract items with dates & time formats only in the same CRF and I successfully exported all these data.
I wonder how can I export CRF data with mixed data format in one go? I appreciate any suggestions or insights into this issue!