PC Review


Reply
Thread Tools Rate Thread

Date comparison between 2 datetime fields

 
 
Rita Brasher
Guest
Posts: n/a
 
      6th Oct 2009
I have 2 cells containing datetime values. I need to compare just the
date portion of the cells. eg: (If( Date(Cell1) <= Date(Cell2),1,0)

By what means can I get there as the example doesn't work.

Thanks in advance for any help you can provide!

Rita Brasher
Project Engineer
FedEx Express / Int'l MIS and Training
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      6th Oct 2009
Just look at the integer portion of the cells:

if int(cell1.value) = int(cell2.value) then



Rita Brasher wrote:
>
> I have 2 cells containing datetime values. I need to compare just the
> date portion of the cells. eg: (If( Date(Cell1) <= Date(Cell2),1,0)
>
> By what means can I get there as the example doesn't work.
>
> Thanks in advance for any help you can provide!
>
> Rita Brasher
> Project Engineer
> FedEx Express / Int'l MIS and Training


--

Dave Peterson
 
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
xml, DateTime conversions and DateTime fields Andy B Microsoft ASP .NET 2 25th Sep 2008 02:43 PM
DateTime problem: how to create datetime format hh:mm:ss AM/PM without the date mimi Microsoft C# .NET 1 6th Aug 2004 08:28 PM
Date Fields Comparison Ify Microsoft Excel Misc 2 1st May 2004 12:27 PM
DateTime Comparison Problems elziko Microsoft VB .NET 4 21st Nov 2003 04:12 PM
DateTime Comparison yue Microsoft C# .NET 1 30th Jul 2003 01:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:14 AM.