jdemetra-app icon indicating copy to clipboard operation
jdemetra-app copied to clipboard

Published 20 hours ago • verified publisher icon jdemetra

Quaterly date pattern

Open soledad-saldana opened this issue 7 years ago • 2 comments

Hello, When we open a new spreadsheet source, it would be helpful for us to be available in Data format the option Quarter in year in date-pattern to allow to include quarterly periods such as 1-2016 (first quarter 2016).

Thank you in advanced.

Soledad Saldaña (INE Spain)

soledad-saldana avatar May 04 '17 08:05 soledad-saldana

This is not possible for the time being since a date-pattern doesn't allow to specify quarterly information. I'm still searching for a solution but it won't be available for v2.2.0.

charphi avatar May 05 '17 09:05 charphi

The current implementation of date parsing uses java.text.SimpleDateFormat which does not support quarter parsing. There is a new date parser in Java8 (java.time.format.DateTimeFormatter) which supports quarter parsing. Unfortunately, these two parsers are not 100% compatible.

Therefore, some kind of compatibility mode needs to be developed and fully tested. It is too late for the upcoming release (v2.2.0) but should be done in the next (v3).

charphi avatar May 05 '17 11:05 charphi