Data Integration
- Data Integration
- All Products
%OPR_IIF[IS_DATE(%dateports%,%fromdateformat%),TO_STRING(TO_DATE(%dateports%,%fromdateformat%),'mm-dd-yyyy'),%dateports%]%
IIF(IS_DATE(StartDate,’mm/dd/yy’),TO_STRING(TO_DATE(StartDate,’mm/dd/yy’),’mm-dd-yyyy’), IIF(IS_DATE(StartDate,’mm/dd/yyyy’),TO_STRING(TO_DATE(StartDate,’mm/dd/yyyy’),’mm-dd-yyyy’), StartDate)) IIF(IS_DATE(EndDate,’mm/dd/yy’),TO_STRING(To_Date(EndDate,’mm/dd/yy’),’mm-dd-yyyy’), IIF(IS_DATE(END _DT,’mm/dd/yyyy’),TO_STRING(TO_DATE(EndDate,’mm/dd/yyyy’),’mm-dd-yyyy’), EndDate))
The example shows the "IsDate" function. This should be corrected to "Is_Date" function.
Hi Patrick Dwyer,
You are correct. Thanks so much for bringing this to our attention! We'll fix it in the next major release.