I have a date field called 'add_date_time' that is in a format of a timestamp from the data source like below
This field is a transaction date and I want to chart sales by transaction date, the problem is that many transactions occur on a date and each transaction is time-stamped. How can I have all transactions that occur on 7/31/2017 show as that date as opposed to individually, based on time, would this be done in the script.
Solved! Go to Solution.
Sunny's expression should work just fine. Incase you have any extra space try this as well
Date(Floor(Date#(Purgechar(add_date_time, ' ') , 'MM/DD/YYYYhh:mm:ss.fff')), 'MM/DD/YYYY') as DateField