Jump to content

filter problem

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
2 replies to this topic

#1
barnigan

barnigan

    Newbie

  • Members
  • PipPip
  • 11 posts
if Sta >= CDate("11/1/2008") then
num = num+1
end if

I am trying to count the number of dates in a csv file that where created scince the beginning of the month, I should be getting 64 instead i eather get everything (3809) if i say >= or 0 if I say<= niether of which are right.
does anyone know what would cause this

#2
barnigan

barnigan

    Newbie

  • Members
  • PipPip
  • 11 posts
fixed it with
if year(Sta) = year(Date()) and month(sta) = month(Date)

#3
Xav

Xav

    Writes binary right handed and hex left handed

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 13,118 posts
Glad you got it working.
Jordan said:

Good members, like yourself, stick around and post for ages to come!
Mr. Xav | Blog | Forums