Logical Help

[Anonymous]

Hi all,

I want to create a new column where New Not Traded where condition is

Customer Account Open Date = Opened in date period

Customer Type = Account or Cash

Sales Value is blank/null in date period

  Customer Brand = J

left side are column name. can you pls help me in first and third requirement??

[neelamsaroha157]

For the sales value blank you can use

either Isnull(date field)

or

len(Trim(DateField)) <1

[neelamsaroha157]

Sorry, It would be  'Sales Value' filed NOT date field

[Anonymous]

and what about Customer Account Open Date

[neelamsaroha157]

I didn't get what you meant by 'Opened in date Period', is it the range of dates???

How do you define 'date period'?

[Anonymous]

okk lets assume account which opened in current year and last year i.e2016 and 2017

[neelamsaroha157]

May be

Year([Customer Account Open Date]) =Year(Today())

OR Year([Customer Account Open Date]) =Year(AddYears(Today(), -1))