Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date

Status
Not open for further replies.
discusmania

discusmania

IS-IT--Management
Oct 24, 2000
158
AP
hi guys....

how to know how many days from date1 to date2?

I do this way:

days=trim(results("date1")-results("date2"))

it works if the month is the same . how about different month? e.g 25 march to 2 april? and different year too?

thanks for the help.

 
Sort by date Sort by votes
discusmania, try this baby:

days=DateDiff("D", date1, date2)

This should be the answer to all your questions (at least for now :) ) Good luck on your app man!


<webguru>iqof188</webguru>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How to display an existing date in Input type=&quot;date&quot;?
Replies
4
Views
245
leifoet
leifoet
leifoet
  • Locked
  • Question
Using date picker gives an error message, only at application start
Replies
1
Views
342
MarkSweetland
MarkSweetland
leifoet
  • Locked
  • Question
How to compare (date+time) with now() ?
Replies
1
Views
136
GriffMG
GriffMG
RonnieKar
  • Locked
  • Question
Date/Time stamp
Replies
4
Views
209
RonnieKar
RonnieKar
penguinspeaks
  • Locked
  • Question
Date woes
Replies
7
Views
197
penguinspeaks
penguinspeaks

Part and Inventory Search

Sponsor

Back
Top