-
comparing dates?
alright. here is my question. I have two boxes with dates. One that has a beginning date, and one that has an ending date. I have a .dat file that contains a list of dates with info. The .dat file looks like this:
#2001-04-11#,"D14","701",.91
#2001-04-11#,"C87","712",2.05
#2001-04-11#,"L12","007",.94
#2001-04-11#,"L12","503",1.22
#2001-04-11#,"L12","102",.32
#2001-04-11#,"L12","711",1.51
#2001-04-11#,"L12","466",1.13
#2001-04-11#,"M32","200",3.73
#2001-04-11#,"M32","712",2.21
#2001-04-11#,"M32","096",1.44
#2001-04-11#,"C87","466",1.16
#2001-04-11#,"C87","201",2.93
#2001-04-11#,"C87","100",.27
#2001-04-11#,"C87","428",2.1
#2001-04-11#,"C87","101",.33
#2002-05-05#,"L12","007",.98
#2002-05-05#,"L12","007",.98
#2002-05-05#,"L12","123",1.23
The .dat file as been inported into my program, and the names of the data have the variables TransDate(K), TransEmpNum(K), TransUPC(K), TransPrice(K) respectivly. How do I sort the data to only pull the information in between the two dates inputed by the user? For example, if the user inputed 2/1/80 as from date and 2/4/02 as to date, how do I have the program pull information in between those 2 dates? DateDiff() ?? What I am planning on doing is then add similar products together, known by product code.. count the amount of units sold and the total value. But if you could help me with the dates, that would be great.
Thanks~
-
WOuldn't it be easier to do this with a database?
-
