IIf ( only returns a date and not a string

Questions & Answers
1

Dear all,

I’m trying a very simple IIf( formula but instead of text it only returns mmm.dd.yyyy.
Does anyone know how to return the text?

Here is the formula:
IIf(
DateCompare([Measures].[Issue End Date],Now()) < 0,
“TextA”,
“TextB”
)

Thank you very much!
Gordon

2

Hi,

Welcome to the eazyBI community!

Your formula seems correct. You may want to change the formatting of the measure to Text → Plain. This is because the first condition in IIF() is a DateTime, therefore, by default, it is expected to return date. Calculated measures and members - eazyBI for Jira

Best,
Ilze / support@eazybi.com

1 Like
3

Dear IIze,

thanks for your reply and the warm welcome!

I just realized that I’m using eazyBI Version 5.2.1 where “Text” is not available.
Are there any alternative solutions?

Thanks again!
Gordon

btw. same result when I use this formula:
CASE
WHEN
DateCompare([Measures].[Issue End Date],Now()) < 0
THEN
“TextA”
ELSE
“TextB”
END

4

Hi,

Select formatting Decimal or Integer (it sounds silly, but it should work).
In both cases, the condition is with a different data type than the result, therefore, formatting is needed.

Best,
Ilze / support@eazybi.com

1 Like
5

Works perfectly. :slight_smile:

Thanks for your support!

1 Like