Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Incorrect date shows under flat form

Resolved
Sergii Valko asked on April 8, 2020

Hello, date with type “year/month/day” shown under flat form only like a year. A similar issue, with date formating, was here and it was solved in the suggested manner, through customizing cell. But under flat form it impossible, due to year reflects only in the data object. Please have a look for example  http://jsfiddle.net/g032ex4o/
Thanks in advance

8 answers

Public
Vera Didenko Flexmonster April 8, 2020

Hello, Sergii,
 
Thank you for reaching out to us.
 
For such a case, our team kindly suggests using the date string date data type
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/vdLgraf0/
 
Please let us know if this would work for you.
 
Looking forward to your reply.
 
Kind regards,
Vera

Public
Sergii Valko April 9, 2020

Hello Vera, thanks for your response. But in case of using ‘date string’ type, I lose the opportunity to filter by this field with such conditions as ‘before’, ‘after’, ‘between’ etc, what is unacceptable.

Public
Vera Didenko Flexmonster April 9, 2020

Hello, Sergii,
 
Thank you for your reply.
 
We have not managed to reproduce the problem with date filters not being available for fields of type date string.
Please see the following JSFiddle for illustration: https://jsfiddle.net/flexmonster/62fk1d9q/
In the example, when the “Apply Date Filter” button is clicked, the before date filter is applied. 
 
Please let us know if this works on your end.
 
Looking forward to your reply.
 
Kind regards,
Vera

Public
Gennady Gandelman April 17, 2020

Hi Vera,

The problem with using string is we are losing the ability to filter individually by year, month, and day. It’s a great feature our users will appreciate, so we don’t want to compromise by getting rid of it. Do you have a solution for being able to stick with “year/month/day”, in order to have the filtering capability like described, and have the values reflect as a full date in the flat layout? If not, are you expecting that a solution will be implemented at some point?

Regards,

Gennady

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster April 17, 2020

Hi Gennady,
 
Thank you for writing to us.
 
Taking into account the number of requests for this feature, we’ve decided to update this behavior so that the “year/month/day” and “year/quarter/month/day” fields are formatted correctly in the flat view. This is going to be provided with our minor release 2.8.7 ETA May 18th.
 
Please let us know if you have any other questions we can help you with.
 
Best regards,
Mykhailo

Public
Gennady Gandelman April 17, 2020

Hey Mykhailo,
 
That’s good news! Thanks so much.
 
Gennady

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster May 19, 2020

Hi Gennady & Sergii,
 
We are glad to inform you that now the flat view shows all levels with year/month/day and year/quarter/month/day date types.
 
This is provided in the 2.8.7 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component. Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/ 
 
Please let us know if everything works well for you.
 
Best regards,
Mykhailo

Public
Gennady Gandelman May 19, 2020

Thank you for making this update!

Please login or Register to Submit Answer