web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Active Discussion

Filtering on a temporary table

(0) ShareShare
ReportReport
Posted on by 50

Hi everyone,
I want to filter with a data range on Customized Calendar Changes(Base Calendar) table, but I can't do it because it is a temporary table and it has nothing. The table fills with information when the user opens it. Can anyone help me and tell how to filter on it? 

  • Leco Lv Profile Picture
    Microsoft Employee on at

    Hi partner,

    Can you tell us which dynamics app you are using? you can also provide us with screenshots if convenient.

  • Reni Profile Picture
    50 on at
    [quote user="Reni"]

    Hi everyone,
    I want to filter with a data range on Customized Calendar Changes(Base Calendar) table, but I can't do it because it is a temporary table and it has nothing. The table fills with information when the user opens it. Can anyone help me and tell how to filter on it? 

    [/quote]

  • Reni Profile Picture
    50 on at
    [quote user="Reni"]

    Hi everyone,
    I want to filter with a data range on Customized Calendar Changes(Base Calendar) table, but I can't do it because it is a temporary table and it has nothing. The table fills with information when the user opens it. Can anyone help me and tell how to filter on it? 

    [/quote]

  • Reni Profile Picture
    50 on at

    I want to filter with a specific period of time (from first day of month to last day of month) on Date field and for that period I want to count the  Working Days (from Monday to Friday).

    pastedimage1667895025389v1.png

  • Leco Lv Profile Picture
    Microsoft Employee on at

    Hi partner,

    Please post your question on the corresponding forum, the following is the link to the dynamics 365 business central.

    Dynamics 365 Business Central - Forums, Blogs, Support

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Pallavi Phade Profile Picture

Pallavi Phade 102 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 67

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans