Converting Varchar data into Datetime
Hi everyone,
I’ve been trying to convert data I’m receiving from a varchar (20171211 125023) into a datetime (2017-12-11 12:50:23). I’ve been messing with the mapper but I feel like I’m at a road b...
Forum Discussion
Yes, That’s correct.
When I insert my schema this is what I get.
Could not compile expression: Date.parse($MODDATE,“yyyyMMdd … (Reason: Invalid token: ‘“’ for expression: Date.parse($MODDATE,“yyyyMMdd …; Resolution: Please check expression syntax)
Can you give me the complete expression you are providing and the error as well.
Of course,
expression:
Date.parse($MODDATE,“yyyyMMdd hhmmss”).toLocaleDateTimeString({“format”:“yyyy-MM-dd hh:mm:ss”})Validation errors:
property_map.settings.transformations.value.mappingTable.value[2].expression.value: Could not compile expression: Date.parse($MODDATE,“yyyyMMdd … (Reason: Invalid token: ‘“’ for expression: Date.parse($MODDATE,“yyyyMMdd …; Resolution: Please check expression syntax)Matt,
If you copy the expression from here, it will have different quotations (" "). Try to type the entire expression in the mapper instead of copying it from here. It works.
