timestamped date to only date

Options

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!

Best Answers

  • ColemenWilson
    edited February 8 Answer ✓
    Options

    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.

    If I solved your problem, please select "yes" above

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    DATE will work. There’s also DATE_TRUNC

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • ColemenWilson
    edited February 8 Answer ✓
    Options

    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.

    If I solved your problem, please select "yes" above

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    DATE will work. There’s also DATE_TRUNC

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**