HOW TO SEGREGATE NEW VS EXISTING CUSTOMERS WHERE NEW CUSTOMERS ARE AFTER 1 APRIL 2013

[abhaysingh]

HOW TO SEGREGATE NEW VS EXISTING CUSTOMERS WHERE NEW CUSTOMERS ARE AFTER 1 APRIL 2013

[#2]

Hi,

Try this in script

if(Datefield>='01/04/2013',CUSTOMERS) as NEW customers,

if(Datefield<'01/04/2013',CUSTOMERS) as Existing customers,

Hope it will work........