Why do I get a Null value?

[southbean]

Hello All,

I’m trying to solve a larger problem with this smaller problem. Here’s my formula:

Local DateTimeVar SolvedDate1 := DateTime({PROBLEMS.SOLVED_DATE},{PROBLEMS.SOLVED_TIME});
Local DateTimeVar ClosedDate1 := DateTime({PROBLEMS.CLOSE_DATE},{PROBLEMS.CLOSE_TIME});

WhilePrintingRecords;
If SolvedDate1 = DateTime(0,0,0,0,0,0) Then
ClosedDate1 
Else
SolvedDate1

The problem is this: When there is a record with a SolvedDate1 date populated and a ClosedDate1 that is Null the formula returns a null value. Why?!?!?

Any and all help with this would be greatly appreciated!!!

- t

 

[kskid]

Try this

Local DateTimeVar SolvedDate1 := DateTime({PROBLEMS.SOLVED_DATE},{PROBLEMS.SOLVED_TIME});
Local DateTimeVar ClosedDate1 := DateTime({PROBLEMS.CLOSE_DATE},{PROBLEMS.CLOSE_TIME});

WhilePrintingRecords;
If isnull(SolvedDate1) or SolvedDate1 = "" then
  ClosedDate1
ELSE
  SolvedDate1

-LW

 

[kskid]

Change that

Local DateTimeVar SolvedDate1 := DateTime({PROBLEMS.SOLVED_DATE},{PROBLEMS.SOLVED_TIME});
Local DateTimeVar ClosedDate1 := DateTime({PROBLEMS.CLOSE_DATE},{PROBLEMS.CLOSE_TIME});

WhilePrintingRecords;
If isnull(SolvedDate1) or SolvedDate1 = date(0,0,0,0,0,0) then
  ClosedDate1
ELSE
  SolvedDate1

 

[southbean]

Hello kskid,

Thank you for your reply. I did try something similar (I should have posted that). I get an error message of: "A field is required here" in the 'isnull(SolvedDate1)' section.

Removing that, I still get the same result.

Thanks again!

- t