How do I exclude data with a future date?

kim_barragan0126
kim_barragan0126 Member
in App Studio

I am trying to pull data on a daily basis of headcount, but I have data that has future start dates that I want to exclude. Is there a beast mode I could do so?

For example, today, I want to exclude any date after 12/19/2024. I would need to have a beast mode filter out daily any future date data. Is this doable?

StartDate

1/13/2025

1/13/2025

1/7/2025

12/27/2024

12/26/2024

12/23/2024

12/23/2024

12/21/2024

12/21/2024

12/20/2024

12/19/2024

12/19/2024

12/19/2024

12/19/2024

12/19/2024

12/18/2024

12/18/2024

12/18/2024

12/18/2024

12/18/2024

12/18/2024

12/18/2024

12/18/2024

12/18/2024

12/18/2024

12/18/2024

12/18/2024

12/17/2024

Best Answer

  • kim_barragan0126
    kim_barragan0126 Member
    Answer ✓

    Perfect! Thank you. I also used it to omit End Dates in the past. I appreciate the learning!

    CASE WHEN ActualEndDate< NOW() THEN 1 ELSE 0 END

Answers

  • GrantSmith
    GrantSmith Coach

    You can use a beast mode calculate if it's a future date:

    CASE WHEN `StartDate` > TODAY() THEN 1 ELSE 0 END

    Then just filter for 0 in the beast mode.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • kim_barragan0126
    kim_barragan0126 Member

    Thank you! But I am getting an error.

    image.png

  • GrantSmith
    GrantSmith Coach

    Sorry getting my languages mixed. You can use NOW() instead of TODAY()

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • kim_barragan0126
    kim_barragan0126 Member
    Answer ✓

    Perfect! Thank you. I also used it to omit End Dates in the past. I appreciate the learning!

    CASE WHEN ActualEndDate< NOW() THEN 1 ELSE 0 END

Categories