Remove Timestamps from Calendar Date - GetPivot on Excel

[naigen]

Hi all,

I'm currently building a model on excel that will allow me to reference a date column in a powerpivot using some excel formulas. 

the data is imported via powerquery and dax within excel.

so below is a example of data from the pivot table of the number im trying to bring in:

However when i try refrencing the table it has the below date format:

ideally what should be in the yellow column is: "01/03/2022"

When I look into the data model the date has a timestamp!

As you can see from the above this calender date includes a timestamp.

I'm not sure what I can do to get rid of the timestamp.

ideally I want to be able type a date into excel such as "01/03/2022" use the GET PIVOT function to refrence that date.

any help would be greately appreciated as I am unable to find anything on the web about this subject

[v-yalanwu-msft]

Hi, @naigen ;

Try it.

1.Click the Home tab

2.In the Number group, click on the drop-down

3.Select Short date (or Long Date) – based on how you want the date to be displayed.

https://trumpexcel.com/remove-time-from-date-in-excel/

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.