+ Reply to Thread
Results 1 to 2 of 2

Date Comparison

  1. #1
    Registered User
    Join Date
    05-09-2011
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    44

    Date Comparison

    Hi all, I have a problem with dates comparison and hoping someone could assist or point me to the right direction.

    Here's the situation :

    I have two fields

    1) Date Created : Consists of date and time (eg. 11/1/2010 8:28)
    2) Date last modified : Consists of only date (eg. 11/3/2010)

    I'm trying to do a comparison between Date Last Modified and Date Created. If Date Last modified is lesser or the same as Date Created it should be flagged as an error. In my case it should return the numeral 1 as an error.

    The comparison works but not for the same day. No matter what i tried it seems to pick it up as an error.

    Here is the formula I used.

    =IF([@[Date Modified]]<=int([@[Date Created]]),1,0)

    Would really appreciate it if someone could help me out.

    Thanks in advance.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Date Comparison

    Hi treeantz,

    I get
    Please Login or Register  to view this content.
    Find the attached:
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1