Forum Discussion

Marit's avatar
Marit
Icon for Helper II rankHelper II
6 years ago
Solved

Lastdate, how to remove the time?

Hi!   I am using the lastdate function to show the last date. However, both the date and the time is showing. Even though I have changed the format of the date colum to only show the date in my dat...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    @Marit

    It should work as long as the column is formatted as a date column. Can you share the measurement?

    You can test your : FORMAT([Your measure],"dd/mmm/yyyy")

    Thank you

    Fowmy

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

Marit 

You can format it to show only the date. Select the measure and choose a date format that has no time formatting.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply šŸ™‚

YouTube  LinkedIn

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply šŸ™‚

YouTube  LinkedIn

 

  • Marit's avatar
    Marit
    Icon for Helper II rankHelper II
    6 years ago

    I have allready done this, but the time is still showing.

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      6 years ago

      @Marit

      It should work as long as the column is formatted as a date column. Can you share the measurement?

      You can test your : FORMAT([Your measure],"dd/mmm/yyyy")

      Thank you

      Fowmy

      • Marit's avatar
        Marit
        Icon for Helper II rankHelper II
        6 years ago

        That worked fine, thank you a lot!