Date format in table filter

[Former Member]

Hi,

I am facing one problem regarding date format in table filter.

Filter for column with date field is working only if filter value is entered in the format MM/dd/yyyy. Its not working for any other format like dd.MM.yyyy.

Anyone have faced this problem earlier?

What can be done so as to convert entered date into required format?

Regards,

Apurva

[Former Member]

Modified Tablefilter.java file.

Problem Solved.

Thank everyone,

Apurva

[Former Member]

Apurva,

Please let me know how did you resolve table filter issue. In our case, date format is MM/dd/yyyy.

I modified following changes of the line in the method generateObject,

SimpleDateFormat template = new SimpleDateFormat("MM-DD-YYYY");

and I tried with "MM-dd-yyyy".

Please note I have created SimpleType with representation as MM-dd-yyyy and have associated same thing to

-Source node

- Target node as well.

Please guide

Regards,

Ganga

[Former Member]

You may use SimpleDateFormat for e.g,

SimpleDateFormat template = new SimpleDateFormat("MM/dd/yyyy");

template.format("date in other format");

[Former Member]

Hi Apurva,

Check existing thread in which this problem is resolved:

Regards,

Anagha

[Former Member]

Hi Anagha,

Thanks for reply.

But I am facing problem in case of filter and not sorter.

Regards,

Apurva

[Former Member]

HI,

Create a simple type of Date and in the representaion part specify the format which you want as dd/MM/YYYY or as you wish and map this type to the type of the attribute in the context

Regards

Padma N