AnsweredAssumed Answered

Dates in Case or If Statements

Question asked by soco1509 on May 20, 2017
Latest reply on May 27, 2017 by soco1509

hi,

 

help would be greatly appreciated,

 

in the data viewer while testing i wish to on the "fly" test results of date fields,

 

i know this works

 

Case(

Aged WIP Report::Date >Aged WIP Report::test date;1;

Aged WIP Report::Date = Aged WIP Report::test date;2;

0)

 

What i would like to do is, alter the xx/xx/xxxx in the case statement by entering actual dates, 01/02/2017 etc,

 

Case(

Aged WIP Report::Date >  xx/xx/xxxx;1;

Aged WIP Report::Date = xx/xx/xxxx;2;

0)

 

can this be done?

 

if so what would the syntax be?

 

Regards

 

Stephen

Outcomes