Date Field

[evansabres]

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.

[vishsaggi · Accepted solution]

Try this?

Date(Floor(Timestamp#(add_datetime, 'M/D/YYYY hh:mm:ss.fff')), 'M/D/YYYY')

[pradosh_thakur]

Time stamp #..

[evansabres]

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