Fixed
Pinned fields
Click on the next to a field label to start pinning.
Details
Components
Assignee
Dan CamperDan CamperReporter
Kevin GarrityKevin GarrityPriority
MajorCompatibility
MajorFix versions
Labels
Pull Request URL
Affects versions
Details
Details
Components
Assignee
Dan Camper
Dan CamperReporter
Kevin Garrity
Kevin GarrityPriority
Compatibility
Major
Fix versions
Labels
Pull Request URL
Affects versions
Created June 5, 2018 at 2:11 PM
Updated September 6, 2018 at 11:17 AM
Resolved September 6, 2018 at 11:17 AM
The following code only cleans the first date format:
dateFullYr := '06/04/2018';
date2DgtYr := '06/04/18';
fmtsin := [
'%m/%d/%Y',
'%m/%d/%y'
];
fmtout:='%Y%m%d';
OUTPUT(dateFullYr,NAMED('dateFullYr'));
OUTPUT(date2DgtYr,NAMED('date2DgtYr'));
OUTPUT(Std.date.ConvertDateFormatMultiple(dateFullYr,fmtsin,fmtout),NAMED('CleanedDateFullYr'));
OUTPUT(Std.date.ConvertDateFormatMultiple(date2DgtYr,fmtsin,fmtout),NAMED('CleanedDate2DgtYr'));
WU on Prod: W20180605-100640-2
'06/04/18' returns as blank.
This worked using 6.2.24: W20180528-165002 (Prod)
Reversing the order of the fmtsin will incorrectly clean '06/04/2018': W20180605-100954 (Prod)