Review M-Files on G2 & get a $25 gift card Arrow right Review us!

Options
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 13 subscribers
  • Views 34 views
  • Users 0 members are here
Related

Filter Date using View

Kawã Ribeiro

Hi all,

Is it possible to filter a date property in a view by day only?

I have a view with the following filters:

  • Year

  • Month

  • Day (Date)?

At the last level, I would like it to display only the day, instead of the full date.

Example (desired result):

  • 20 – X

  • 21 – X

This way, I would see only the day number, not the full date like "20/01/2025".

Could you help me with that?

  • 0

    I believe this isn't directly possible with the view options. I would first stop and ask if it is really necessary to have the third grouping level by the day. Would it be enough to have the month grouping and then a column with the date property so you can sort the objects in the chronological order within the month? This is how such views are typically configured.

    If you absolutely need to have the day grouping level for some reason and don't want to see the full date, you may need to calculate the day of the month into a separate property and use this for the grouping level. The automatic calculation can likely be done for instance with Property Calculator.

M-Files
M-Files Support


© 2024 M-Files, All Rights Reserved.