Luminate date fields contain the date and time of transactions so it can be difficult to work with this field through filters and pivot tables and can also be inconsistent in format. Below are instructions and screenshots to remove the time potion and update the column from a date field to a text.


 

The date column needs to be the last column in the spreadsheet. Highlight the column and click on "text to columns" then click "deliminated" then "next". 


Then choose "space" as the deliminater then click "next".

Then choose "text" and click "finish".



The date column will then spearate into 3 columns - date, time and am or pm. Delete the time and am/pm columns and rename the date column if necessary.