Date Label Syntax DMB0007

building reports desktopintelligence
1

Hi,

= If UserResponse(“ALL” ,“Begin Date”) = “12/31/2999” Else ToDate(UserResponse(“ALL” ,“Begin Date”) ,“mm/dd/yyyy”)

How do I make this date label work?
is a measure. I think that’s where the problem is.
Can anyone help me with this?

Thanks
Candy :? :?

eye_candy :us: (BOB member since 2005-03-18)

2

What is its datatype? An If() should return same data types in both true as well as else part.

Jansi :india: (BOB member since 2008-05-12)

3

Thanks Jansi… datatype is DATE

I have a list of dates in the report. I want to display the Min date in that variable.

eye_candy :us: (BOB member since 2005-03-18)

4

Great. Please also tell what error message you get. Or wrong values?

Jansi :india: (BOB member since 2008-05-12)

5

Error : DMB0007

eye_candy :us: (BOB member since 2005-03-18)

6

Oops. Sorry, I didn’t look at the subject line. Please post the code for

Jansi :india: (BOB member since 2008-05-12)

7

=Min()

Extract Date is datatype DATE

eye_candy :us: (BOB member since 2005-03-18)

8

Did you type in the formula exactly as it is listed in your report? I’d think you were at least missing the then clause:

= If UserResponse(“ALL” ,“Begin Date”) = “12/31/2999” then Else ToDate(UserResponse(“ALL” ,“Begin Date”) ,“mm/dd/yyyy”)

digpen :us: (BOB member since 2002-08-15)

9

Hi Digpen,

Lol yes it was missing “then” in the syntax. How could I have missed it. :shock: :shock: Thanks again! :mrsbob: :cookie: :slight_smile:

eye_candy :us: (BOB member since 2005-03-18)

10

:oops: I never noted it. Good catch. :+1:

Jansi :india: (BOB member since 2008-05-12)