span8
span4
span8
span4
For some reason,I can't read in a date such as
02-JUL-08
using
%d-%b-%y
It says that %y is output only.
Surely there must be a way to read two digit years.
Hi@dta255,the format specifier %y (two-digit year) is not supported to parse a date/time string.See also here:Date/Time Functions
If you are sure that the date always belongs to the 21st century,simply replace the last two digits (xx) in the date string with '20xx',then parse the resulting date string with %d-%b-%Y.
@DateTimeParse(@ReplaceRegEx(02-JUL-08,"^(.+)(..)$",\120\2),%d-%b-%Y)
Hi@dta255
Unfortunately,you've run into a known issue where DateTimeParse function and the DateTimeConverter transformer is unable to read in two digit years.Attached is a workspace that will convert two-digit year values to four-digit years by prefixing '20'.If you have any year values earlier than 2000,you will have to make edits the workspace.
I hope this helps.
2digityear-to-4digityear.fmwUpdate phone numbers based on Excel file (RegEx,AttributeManager or FeatureMerger?)1 Answer
Create a "chaining" based on attributes with common value ?1 Answer
Merging 2 attributes into 1 attribute1 Answer
AttributeManager add a constant to a decimal value1 Answer
Is it possible to copy/paste conditional statements in AttributeManager?2 Answers
© 2019 亚搏在线Safe Software Inc |Legal