Comparing Dates

Results 1 to 2 of 2

Thread: Comparing Dates

  1. #1
    Join Date
    Dec 1969

    Default Comparing Dates

    Hi,<BR><BR>I&#039;m trying to create an asp application which when loaded opens a database, looks at a date field in all records and compares it against the date of the server.<BR>If the difference of the dates in each field is 14 days, I want it to then save the recordid and produce the results on a page.<BR><BR>I&#039;m stuck because i can&#039;t really find any relevant tutorials on the web.<BR><BR>Any help would be appreciated.<BR><BR><BR>Robert

  2. #2
    Join Date
    Dec 1969

    Default RE: Comparing Dates

    all you need is to use a VBScript&#039;s Function:<BR><BR>DateDiff(Interval, Date1, Date2, FirstDayofWeek, FirstWeekofYear) <BR> <BR>The DateDiff function calculates the amount of time between two different dates. <BR><BR>Try to search on the web on how to use this.<BR>Do you have MSDN? Or go to and download a vbscript reference.<BR><BR>It&#039;s very handy. And free!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts