PC Review


Reply
Thread Tools Rate Thread

DateDiff Function behaves differently on NT under .NET Frameowrk

 
 
=?Utf-8?B?VmlkaXQ=?=
Guest
Posts: n/a
 
      23rd Nov 2004
I have a weird behaviour to report.
I am using DateDiff function to do some date comparison.

Its supposed to throw an error if the input date is less than the current
date.
This happens when the dates compared are 11/11/1111 11:11 and current date.
The date comparison works on Windows 2000 and XP but not on Windows NT. The
same date comparison code works in case the date is say 1/11/2003 09:00, but
not for the above mentioned date.
I do
if DateDiff("n", date1, currentDate) > 0 Then
err
Else
no err
Endif
As you can see I dont hold the difference result in a variable.. so it can
be overflow error..

any ideas

thanks

vidit
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application behaves differently on different platforms! Paul Fenton Microsoft Access 6 1st Apr 2007 11:43 PM
Code behaves differently FPS, Romney Microsoft Access Form Coding 2 5th Jan 2007 08:26 PM
Formula behaves differently mtpsuresh Microsoft Excel Worksheet Functions 4 22nd May 2006 12:14 PM
Label AutoSize Behaves Differently from VB6 Charles Law Microsoft VB .NET 2 18th Mar 2005 10:33 PM
Function behaves differently when passed a copy of the dataset JerryK Microsoft ADO .NET 4 11th Feb 2004 04:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:50 AM.