|
-
Apr 29th, 2022, 07:45 AM
#1
Thread Starter
Hyperactive Member
DateAdd Datediff Speed
Hi, I'm looking for speed and these DateAdd and DateDiff functions don't help me, I've seen that varDate + 1 is much faster than DateAdd("d",1,VarDate) is there any contraindication for that??
same with DateDiff date
'If DateDiff("d", varDate1, .varDate2) < 0 Then <----Slow
'If Day(.varDate1) < Day(varDate2) Then <----a little faster
If varDate1 < varDate2 Then <----BEST!
I assume this has no conflict?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|