Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Incorrect Date format in Text box

Hi All, I am creating a measure which returns date in textbox as below  but it returns date as 01-16-2021     how can I get date as 01/16/2021 amitchandak  Thanks
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

I presume you are actually using a Card visual, not a Text Box?

I can't reproduce the problem.  But I don't know how you are creating the [_Title test] measure.  Is it a date?

I also don't understand how the date in [_Title test] is 01/16/2021 yet in [_Title] the format is reversed to 2021-01-16 yet the code you show isn't altering [_Title test]. ARe we missing some piece of the puzzle here?

All I can think is that because you aren't doing an explicit conversion to text - assuming [_Title test] is a date - it is formating it in some default way.

So try doing an explicit conversion using FORMAT()

Also you can simplify your measure to this

 

_Title = "Dashboard " & "(as of " & FORMAT([_Title test], "mm-dd-yyyy" & ")")

 

Here's my PBIX if you want to check out my code to create the date and visual..

Regards

Phil