I can't seem to find an answer to this, but I am sure this must have been asked at some point by someone...
We are currently exporting membership expiry dates and they come out as mm/dd/yyyy (or dd/mm/yyyy, I don't remember exactly haha). But, we would like them to come out as 1 January, 2019 (for example)....or something like that.
Does anyone know if this can be done with a output set element? Or does it always have to be the manual edit after the fact?
Convert the expr_dt to a string in the Data Select column of TR_QUERY_ELEMENT.
I haven't tested this within an output set, but "convert(varchar,expr_dt, 107)" should work for your purposes.