Interval in dates in on custom date field

(1) Share

Report

Posted on by MJ-14061046-0

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

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Gerardo Rentería Ga... 25,547 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

I hope this can help you.

Solved: DateFilter (dynamics.com)

Entering dates and times in Business Central - Business Central | Microsoft Learn

Filtering records with the SetRange, SetFilter, GetRangeMin, and GetRangeMax methods - Business Central | Microsoft Learn

BR

GR

Was this reply helpful? Yes No
Suggested answer

Ben Baxter 6,835 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,022 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Verified answer

MJ-14061046-0 29 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No