duursma commented on issue #3051:
URL: https://github.com/apache/hop/issues/3051#issuecomment-1620701285
Can't be sure but from the looks the 'right' format/mask of the date in the
'filter' was used.
I use format 'yyyy-MM-dd'. After saving and opening the shown date has
format yyyy/MM/dd ....
On selecting that field I get the error:
HopValueException:
constant String : couldn't convert string [2023/02/02 00:00:00.000] to a
date using format [yyyy-MM-dd] on offset location 4
2023/02/02 00:00:00.000
Root cause: ParseException: 2023/02/02 00:00:00.000
Where in your version I just get a popup showing the date and the format
both being 'yyyy/MM/dd ... '
Differences in the xml files:
Mine:
<value>
<isnull>N</isnull>
<length>-1</length>
<mask>yyyy-MM-dd</mask>
<name>constant</name>
<precision>-1</precision>
<text>2023/02/02 00:00:00.000</text>
<type>Date</type>
</value>
Yours:
<value>
<isnull>N</isnull>
<length>-1</length>
<mask>yyyy/MM/dd</mask>
<name>constant</name>
<precision>-1</precision>
<text>2023/01/01 00:00:00.000</text>
<type>Date</type>
</value>
So the date is entered according to the mask, but stored as text using a
different mask.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
