Not very sure what is your intention with the %z format code at the end of the TimeStampFormat option of the [MeasureTest2] measure, but try to remove it first: TimeStampFormat=%Y-%m-%dT%H:%M:%S.
If the time offset is provided the datetime parser **should** detect that the input is zoned and make the necessary ajustements to convert it to the local timezone. At least this is how you do it in Java 8.
If I remove %z the datetime is parsed in local zone, that's not what I want.
--
Beside want I want to achieve, why do I get an error ? I think I followed the doc.
mistic100 wrote: ↑April 10th, 2019, 7:54 pm
Well my intention is to parse the time offset....
If the time offset is provided the datetime parser **should** detect that the input is zoned and make the necessary ajustements to convert it to the local timezone. At least this is how you do it in Java 8.
First you have to extract the time and the offset from [MeasureTest1]. For this you have to use more String measures, each with a properly written substitution. Then you have to make the needed transformation. Problem is that this kind of transformation is easier to be made on Time measures, but it's very hard on String measures, because a Time measure has different string and numeric values, while the String measures don't have a proper numeric value, which here would be needed.
If no one here on the forum will write a proper example here on the forum, tomorrow I'll try to write one, to show you how does it work. I'm sorry, but I have to leave this for tomorrow, because here is almost midnight and I don't work anymore with this. Stay tuned, if you want...
This is what I came up to, the timezone in the input is irrelevant, it is always "+00:00", I just wanted the Time measure to detect it is parsing an UTC date and needs to make the adjustment.