Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Interval in dates in o...
Small and medium business | Business Central, N...
Answered

Interval in dates in on custom date field

(1) ShareShare
ReportReport
Posted on by MJ-14061046-0 17
Hi,

I have a custom field on my sales orders, containing dates.

How do I filter so I get all dates from example; 01-01-2024 to today?

I have tried with 01/01/2024 .. 14/06/2024, but that didn't work at all.

Best Regards
Categories:
Dynamics 365 Business Central
  • Verified answer
    MJ-14061046-0 Profile Picture
    MJ-14061046-0 17 on at
    Interval in dates in on custom date field
    I found a solution;

    By using ".. 24/06/2024" it would take everything before the date specified after ..

    Thanks for all the inputs :)

    Best regards,
    Martin
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,795 Super User 2025 Season 1 on at
    Interval in dates in on custom date field
    Something else to note is that the input in the date filter needs to match the settings you have in your Region settings. If you're entering 14/06/2024 then your region settings should specify and expect a dd/mm/yyyy date format, otherwise you will get an error message.
     
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 5,390 Super User 2025 Season 1 on at
    Interval in dates in on custom date field
    Here is how I would key my filter (without the quotes): "1.1.24.."  This shows me everything with a date from 1/1/24 through today (and technically beyond if there were future postings).  You could also do "1.1.24..t" to end on Today's date.
     
    Copy (without the "") and paste that in and if it works, please mark this as a Verified Answer to let other forum users find the information.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 15,570 Most Valuable Professional on at
    Interval in dates in on custom date field

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,025 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans