Formatting on cells with dates to text

I´m trying to format cell from date to text
Example, from Start date Jan 10 2022 to TBD,
This is because I don’t have a correct date Is it possible to do this?

Hi @Coachen

You may want to create a calculated measure (in Measures) where you substitute issue Start date value with any text (“TBD” or another). You can define any condition when to show the text: for those with future Start dates only or with any Start date value; add more WHEN conditions if you want to display different texts in each case.

The following calculation returns text TBD, if the Start date is in future:

CASE WHEN
  DateCompare([Measures].[Issue Start date], "today")>0
THEN
  "TBD"
END

Select formatting “text”.

Ilze / support@eazybi.com

Hi, thank you for the code example. I have managed to solve it so the input is “TBD” with future start dates.
However, I want to keep the original start dates in issues created before “today”. With the below written code i managed to get “TBD” in those fields but the goal is to get the actual start dates there.

CASE WHEN
DateCompare([Measures].[Issue Start date], “today”)>0
THEN
“TBD”
WHEN
DateCompare([Measures].[Issue Start date], “today”)<0
THEN

What should i put here?

END

Hi
Do you have any solution to my question?

//Gert

Hi,
I am sorry your last comment was left unanswered.

You may want to use function Format() to display any date (and numeric value) as a string:

CASE WHEN
  DateCompare([Measures].[Issue Start date], "today")>0
THEN
  "TBD"
WHEN
  DateCompare([Measures].[Issue Start date], "today")<0
THEN
  Format([Measures].[Issue Start date], "mmm dd yyyy")
END

Hope it works!

Ilze