Skip to content

    • Charting

    Charting

    timestamped date to only date

    Member
    in Charting

    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:

    image.png

    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

    • Coach
      edited February 2024 Answer ✓

      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

    • Coach
      Answer ✓

      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

    • Coach
      edited February 2024 Answer ✓

      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

    • Coach
      Answer ✓

      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!**

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories