Hi All,
I have a problem that I cant solve.
I am importing excel csv data using csv connector
The only piece of data I am importing is one cell
In the cell is a date 01/20/2015
I check this date to be greater than 01/01/2015
I check this date to be less than 01/28/2015
cell a1 = imported data
cell a2=01/01/2015
cell a3=01/28/2015
formula in cell b1 =if(a1>=a2,“true”,“false”)
formula in cell b2 =if(a1<=a3,“true”,“false”)
When I run the preview
I get true in b1 and false in b2
b2 should be true
Is this because it is csv data?
jamie-lill@live.ca (BOB member since 2010-08-05)
(BOB member since 2010-06-23)