Hi,
I am running an asp page that looks up a foxpro database, does a datediff with the variable adm_datediff that can be set to 7, 14, 21, 28. The code below does not seem to work but if i make adm_datediff = "0" then it works allbeit changing everything not just those more than say 7 days old. Can anyone give me any idea about this please, i have two asp books, one is the asp for dummies one, this only mentions the datediff function, and another is a programmers reference from wrox that does not mention this function at all, and i am having trouble finding specific information on datediff.


If datediff("d",adm_date ,adm_tempdate ) > adm_datediff Then
adm_RS("per_f2") = "History"
adm_RS.Update
End If

cheers in advance
~M