Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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:
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 24,816 Super User 2024 Season 2 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 4,915 Super User 2024 Season 2 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 12,181 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans