0

Column Filter Date?

My table's column is grabbing dates from a subtable. How do I filter the results to show a specific date only? The results I get are for the date I want plus all of the dates of records with that date as well as other dates. The filter I'm using works, I just don't want to see the other dates. This is what the column formula looks like:

And this is the filter I have:

4 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    Can you try = “(fill in date)”

    • Mr_K
    • 1 yr ago
    • Reported - view

    Just tried that in both the formula and filter. It does not work.

    • Fred
    • 1 yr ago
    • Reported - view

    For the formula you can try:

    concat('Previous Order'['Date of Previous Order' = date(2022, 10, 17)].'Date of Previous Order')

    I’m guessing ‘Date of Previous Order’ is a date field.

    • Mr_K
    • 1 yr ago
    • Reported - view

    Thanks Fred, that works.

Content aside

  • 1 yr agoLast active
  • 4Replies
  • 79Views
  • 2 Following