General Ledger
Active Member
- Joined
- Dec 31, 2007
- Messages
- 460
I have a table of transactions and each record has a date and time stamp.I don’t care about the time portion.Must I create a calculated column in order to get a field of transaction dates?Is there a way to truncate the date and time field before it comes into my table in PowerPivot?I don’t have the ability to make changes to the table in the database. What is the best function to use to trim the time off a date field? I am very new to PowerPivot and using Excel 2010.
Thanks,
G/L
Thanks,
G/L