Format date in script

[evansabres]

I have a field called [Event Date] that is formatted as follows in my data:

10/4/2018  7:00:00 PM

I have attempted to do the following in my script:

DATE([Event Date], 'MM/DD/YYY')                    AS               eventDATE

I am doing this to get that field to link to other tables. However when I run the script, this creates duplicate values for each date:

10/4/18

10/4/18

10/6/18

10/6/18

etc.

etc

Am i formatting this incorrectly in the script?

[nsetty]

Try

DATE(Timestamp#([Event Date], 'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY') AS [Event Date]

[evansabres]

When I do this in my script, the output appears as a dash "-"

[sunny_talwar · Accepted solution]

Try this

Date(Floor([Event Date]), 'MM/DD/YYY')                    AS               eventDATE

[evansabres]

This worked wonderfully, thank you