# Drill-Through Date Formatting while Using a Date Drill **URL:** \ **Category:** Ask the Community\ **Tags:** dashboard, drill\ **Created:** [September 11, 2024, 7:32pm UTC](https://community.holistics.io/t/drill-through-date-formatting-while-using-a-date-drill/2078 "2024-09-11T19:32:33Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![hannah.paxton](https://community.holistics.io/user_avatar/community.holistics.io/hannah.paxton/32/2117_2.png) [@hannah.paxton](https://community.holistics.io/u/hannah.paxton)\ **Post date:** [September 11, 2024, 7:32pm UTC](https://community.holistics.io/t/drill-through-date-formatting-while-using-a-date-drill/2078/1 "2024-09-11T19:32:33Z")
Hello, I am applying a Drill Through in a Canvas Dashboard to a date field. The date field is also linked to a Date Drill. As I attempt to drill through, the date wants to pass through as a Year-Month-Day, even if I want it to pass through at a larger aggregation set by the Date Drill (e.g., Month, Quarter, Year.) Is there a way to pass a date only at the aggregation I set in the date drill (e.g., an aggregation of Month would be passed through as 2024-08 instead of 2024-08-01)? ---
**Author:** ![Theodore](https://community.holistics.io/user_avatar/community.holistics.io/theodore/32/832_2.png) [@Theodore](https://community.holistics.io/u/Theodore)\ **Post date:** [September 12, 2024, 11:17am UTC](https://community.holistics.io/t/drill-through-date-formatting-while-using-a-date-drill/2078/2 "2024-09-12T11:17:10Z")
Hi @hannah.paxton, This case is very interesting. Would you mind sharing some examples of the dashboards you’re currently using? It would help us understand the situation better. Thank you 😄 ---
**Author:** ![hannah.paxton](https://community.holistics.io/user_avatar/community.holistics.io/hannah.paxton/32/2117_2.png) [@hannah.paxton](https://community.holistics.io/u/hannah.paxton)\ **Post date:** [September 12, 2024, 1:26pm UTC](https://community.holistics.io/t/drill-through-date-formatting-while-using-a-date-drill/2078/3 "2024-09-12T13:26:17Z")
Of course! This is an example of a drill-through I have set up. The Cycle Started Bucket is a Date Drill, where I have selected Month. As I attempt to drill through the column that has the active tooltip (Aug 2024), the date is passed through as 2024-08-01 to my target drill through. This limits me to only seeing data for cycles that started on exactly 2024-08-01 rather than data for any cycle that started in 2024-08 ![dashboard](https://community.holistics.io/uploads/default/original/2X/4/4360eecf1b77caa33db84d2f2af2f90b256cc412.png) ![target_drill](https://community.holistics.io/uploads/default/original/2X/f/f2b6da7d712d2590a845f86652a8f80002ebdb33.png) ---
**Author:** ![Theodore](https://community.holistics.io/user_avatar/community.holistics.io/theodore/32/832_2.png) [@Theodore](https://community.holistics.io/u/Theodore)\ **Post date:** [September 13, 2024, 7:41am UTC](https://community.holistics.io/t/drill-through-date-formatting-while-using-a-date-drill/2078/4 "2024-09-13T07:41:34Z")
Hi @hannah.paxton, Thank you for bringing this issue to our attention. The behavior you’re encountering is not intended, and we are actively working on a fix. I’ll keep you updated as soon as the issue is resolved. Thank you for your patience and understanding! ---
**Author:** ![hannah.paxton](https://community.holistics.io/user_avatar/community.holistics.io/hannah.paxton/32/2117_2.png) [@hannah.paxton](https://community.holistics.io/u/hannah.paxton)\ **Post date:** [September 13, 2024, 6:57pm UTC](https://community.holistics.io/t/drill-through-date-formatting-while-using-a-date-drill/2078/5 "2024-09-13T18:57:04Z")
All good - thank you! ---
**Author:** ![Theodore](https://community.holistics.io/user_avatar/community.holistics.io/theodore/32/832_2.png) [@Theodore](https://community.holistics.io/u/Theodore)\ **Post date:** [September 19, 2024, 5:54am UTC](https://community.holistics.io/t/drill-through-date-formatting-while-using-a-date-drill/2078/6 "2024-09-19T05:54:11Z")
Hi @hannah.paxton, The issue has been resolved. Could you take a look to see if it works as you expected it? Cheers 🤟 ---
**Author:** ![hannah.paxton](https://community.holistics.io/user_avatar/community.holistics.io/hannah.paxton/32/2117_2.png) [@hannah.paxton](https://community.holistics.io/u/hannah.paxton)\ **Post date:** [September 19, 2024, 6:28pm UTC](https://community.holistics.io/t/drill-through-date-formatting-while-using-a-date-drill/2078/7 "2024-09-19T18:28:24Z")
This appears to have the expected behavior - thank you!