Date parameter in a Multi Box object

[#1]

Hi all,

I am trying to use the date parameter below in a multi box object

=WHERE ([Sales Date] > '31/12/2009')

I used the steps below but no success:

Multi Box Properties

     General Tab

                    Edit (and Expression) Boxes

                                   =WHERE ([Sales Date] > '31/12/2009')

                                                                                Apply

                                                                                          Ok

Please kindly assist on how to go about this.

Regards

[PrashantSangle]

Hi,

Can you write complete expression??

Regards

[#3]

I can write COUNT and SUM expressions but not WHERE DATE GREATER THAN.

Regards

[PrashantSangle · Accepted solution]

Hi,

Use if()

try like

if(sales date>'31/12/2009','Apply','ok')

Regards

[#5]

Thanks, it works