BC Date filter to always show yesterday but exclude weekends (Monday's yesterday is friday)

(1) Share

Report

Posted on by jk12984

Not sure this is possible but chekcing here if anyone has a simple solution. Trying to use a standard date filter that always show yesterday but exclude weekends (Monday's yesterday is friday).

example -1d<>WD6|WD7

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Brett F 454 on at

Like (0)

Report
Copy link

Link copied!

I would like to know if this is possible as well. Nothing I've tried has worked.

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,840 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Current filter has several wrongs in it:

WD6 and WD 7 returns current week's 6th and 7th day, so on monday it will check if it is not next saturday/sunday. So You would need to add a minus sign -so it is previous week "-WD6" will give last saturday.

Correct version of your filter would be "-1D&<>-WD6&<>-WD7" , but this will work on Tuesday to Saturday. But for Sundays and Mondays this would just return an empty list and You would need a filter "-3D&<>-WD6&<>-WD7". There is no option to have conditions or IF in filters, therefore I don't think this is possible with standard options.

A customization would require to check the current day and apply filter based on result - either -1D on tuesday till saturday, -2D on Sundays and -3D on mondays.

just adding link to other examples:
How to: Enter Dates and Time - Dynamics NAV | Microsoft Learn

Was this reply helpful? Yes No
Verified answer

KasparsSemjonovs 4,840 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Actually gave it some more thought and I think this filter could work - at least it works on my tests :)
-3D&<>-WD1&<>-WD2&<>-WD3&<>-WD4&<>-WD6&<>-WD7|-1D&<>-WD6&<>-WD7

or to make this shorter:
-3D&-WD5|-1D&<>-WD6&<>-WD7

It filters on -3D but shows it only if it is last friday, and it filters on -1D and hides last saturday and last sunday. So on Sunday You will not get anything shown. If You need on Sunday to also show Friday, then use this:
-3D&-WD5|-1D&<>-WD6&<>-WD7|-2D&-WD5

Was this reply helpful? Yes No
jk12984 19 on at

Like (0)

Report
Copy link

Link copied!

Thanks Kaspars! I'll give that a try. Joe

Was this reply helpful? Yes No

Join the conversation

Community site session details

BC Date filter to always show yesterday but exclude weekends (Monday's yesterday is friday)

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

BC Date filter to always show yesterday but exclude weekends (Monday's yesterday is friday)

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates