By using this website, you agree to our Terms of Use (click here)
Hello Everyone,
I'm in a bit of a predicament and I'm looking for help.
I created a pivot table on top of one of my generic inquiries. My generic inquiry is a list of Accounts Payable Bills with their due dates. I'm totaling the Balance due on each Bill and I want to see the amounts due grouped by Due Date.
But I don't want to see the Time after the Date on each Due Date. Note the 12:00:00 AM after each date in the following screenshot:
Does anyone know how to get rid of the Time after the Date?
Hi Piggy,
You can control the formatting of the Due Date column by using the Format property.
To remove the Time, you can use the following format property. Note that I'm also using a format that puts a leading zero in front of the month and the day when the month or day is a single digit.
MM/dd/yyyy
The result looks like this:
This will totally work. Good point too about the leading zeros. That looks much nicer. Thank you!