if

[smilingjohn]

Hi All

i have this query in my edit script

if(DEPT_Code = 'COS',Date([lastSalesMatchDate] ,'YYYY-MM-DD'),Date(MonthStart(today()),'YYYY-MM-DD')) as [date]

In the above DEPT_Code   i need to include even DOT  also how do i write this 

if(DEPT_Code = 'COS',DOT,......) ?

[#2]

Try this

if(match(DEPT_Code = 'COS','DOT'),Date([lastSalesMatchDate] ,'YYYY-MM-DD'),

Date(MonthStart(today()),'YYYY-MM-DD'))

Thanks,

Balakrishnan.R

[avinashelite · Accepted solution]

Try like this

if(DEPT_Code = 'COS' or DEPT_Code = 'DOT' ,Date([lastSalesMatchDate] ,'YYYY-MM-DD'),Date(MonthStart(today()),'YYYY-MM-DD')) as [date]

[sunny_talwar]

Match doesn't need an equal sign... may be this

If(Match(DEPT_Code, 'COS', 'DOT'), Date([lastSalesMatchDate], 'YYYY-MM-DD'),

Date(MonthStart(Today()), 'YYYY-MM-DD'))

[Aurelien_Martinez]

Hi,

if(Match(DEPT_Code, 'COS', 'DOT')>0, Date([lastSalesMatchDate] ,'YYYY-MM-DD'),Date(MonthStart(today()),'YYYY-MM-DD')) as [date]

[#6]

Yes, apologies.

Match does not need an equal sign.