Date issue with if Statement
Hi,
I have a problem that I just can't figure out.
I have a data list and I only want to pick out entries which fall on a
specific date or before that but for some reason its not picking up the
entries. It works if I use an = operand but not for <= operand inorder
to get the previous dates aswell.
syntax
Filter_Date = "27/08/2006"
Data_Date = 'Value taken from workbook
if Data_Date <= Filter_Date then
code
endif
Can anyone shed any light on this??
Thanks
Dwight
|