PC Review


Reply
 
 
Southern at Heart
Guest
Posts: n/a
 
      26th Mar 2010
I have 2 dates, like this:
3/10/2010

and I need to make sure the 2nd one is a later date than the first one. How
can I do this?
(sorry if this is double posted, pc crashed)
 
Reply With Quote
 
 
 
 
Stuart McCall
Guest
Posts: n/a
 
      26th Mar 2010
"Southern at Heart" <(E-Mail Removed)> wrote in
message news:506B487E-8F47-4CA9-98AA-(E-Mail Removed)...
>I have 2 dates, like this:
> 3/10/2010
>
> and I need to make sure the 2nd one is a later date than the first one.
> How
> can I do this?
> (sorry if this is double posted, pc crashed)


Assuming your dates are in variables Date1 and Date2, both declared as Date

If Date2 > Date1 Then
MsgBox "2nd date is later"
End If


 
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
Check on Dates. jfaz Microsoft Access Form Coding 2 25th Apr 2008 01:47 PM
Check Dates Laudrup Microsoft Access 2 17th Feb 2007 01:06 AM
Hotel Check-in and Check-out dates =?Utf-8?B?Q3JlYXRpbmcgRm9ybXVsYSBpbiByZXBvcnQ=?= Microsoft Access 1 27th Aug 2006 08:07 PM
Check Dates John Microsoft Excel Programming 2 13th Sep 2004 06:36 PM
check between 2 dates Paul Watkins Microsoft Excel Misc 3 19th Apr 2004 12:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:49 PM.