timestamped date to only date

Victoria_G1

Hello everyone,

Is there a way to work out the formatting of dates that are originally dates with timestamps to only dates without having to change anything inside the ETL? Screenshot below:

Basically, I want to remove the timestamp part and just keep the date. Is there a way to work out this formatting on the dashboard?

Thanks!

ColemenWilson

I’m not at my computer to verify so someone please correct me if I am wrong, but the only way to do it would be in a beastmode and share the beastmode to the dataset or in the ETL.

for beastmode it would be:

DATE(yourDateField)

in ETL it would be using the date tile or a formula tile with the above beastmode.

GrantSmith

DATE will work. There’s also DATE_TRUNC

ColemenWilson

I’m not at my computer to verify so someone please correct me if I am wrong, but the only way to do it would be in a beastmode and share the beastmode to the dataset or in the ETL.

for beastmode it would be:

DATE(yourDateField)

in ETL it would be using the date tile or a formula tile with the above beastmode.

GrantSmith

DATE will work. There’s also DATE_TRUNC