Does data type should be same in set analysis?
oderdate is in text format and 201712 is in date format.
The above one is not working.Kindly help
Thanks & Regadrs,
Yes it should be same.
Try to put it btwn doubles quotes as a first test.
orderdate is text format? If that is true this may not work... but are you sure it is text? may be it is a number?
Yes, orderdate is in text format.
May be try this
Retrieving data ...