How to convert unix timestamp to date only

[mdubose]

Hello,

I'm able to convert my column using the formula below.  It converts the column to a text data type. and results into a date/time field.  I want the field to display as date only.  Is this possible? Thank you.

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [startDate]/1000)

[SK__]

I tried using the same, but facing an issue. 

timestamp = DATETIME(1970, 1, 1, 0, 0, 0) + duration(0, 0, 0, 'data'[timestamp])

Issue - 

Failed to resolve name 'DATETIME'. It is not a valid table, variable, or function name.

How to resolve this issue? 

[amitchandak · Accepted solution]

@mdubose , if the conversion is correct. Just change the data type to date in power query 

or use in power query

DateTime.Date([You Date Time COlumn])