View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dewey Dewey is offline
external usenet poster
 
Posts: 16
Default 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