Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date field called 'add_date_time' that is in a format of a timestamp from the data source like below
7/31/2017 18:10:51:026 |
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.
Try this?
Date(Floor(Timestamp#(add_datetime, 'M/D/YYYY hh:mm:ss.fff')), 'M/D/YYYY')
Time stamp #..
This could very well be the correct solution. My field seems to be a bit tricky for whatever reason and is not responding to any formatting