Forum Discussion
Date table not filtering other tables
I have three tables and am trying to use the date table to filter the other two. I have a table to display the Actual and Planned fuel by month. The actual fuel shows one value for a month with a null value and leaves January blank. All files and photos are in the link below. I have searched everywhere but can't figure this out. Any help will be greatly appreciated.
https://drive.google.com/drive/folders/1Y3ik1fMtYjqw146GXqGDwgjMQK0haxM7?usp=sharing
Anonymous , This means there few dates missing in date table.
Also, the check dates do have a timestamp. if there is then create date like below and join with date table
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime]))
2 Replies
- amitchandak
Super User
Anonymous , This means there few dates missing in date table.
Also, the check dates do have a timestamp. if there is then create date like below and join with date table
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime])) 
v-henryk-mstfCommunity Support
Hi Anonymous ,
The above problem may be caused by setting an incomplete time stamp, which results in some field values without corresponding dates. I did the following test and got the correct expected result.
Table = CALENDAR("2021-01-01","2021-03-31")
If the problem is still not resolved, please provide detailed error information, and let me know immediately. Looking forward to your reply.Best Regards,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.