Results 1 to 8 of 8

Date function that compare 2 date in single column and return value

Threaded View

alimamak Date function that compare 2... 07-19-2012, 11:02 PM
dilipandey Re: Date function that... 07-19-2012, 11:48 PM
alimamak Re: Date function that... 07-20-2012, 12:00 AM
dilipandey Re: Date function that... 07-20-2012, 12:04 AM
alimamak Re: Date function that... 07-20-2012, 12:17 AM
dilipandey Re: Date function that... 07-20-2012, 12:25 AM
alimamak Re: Date function that... 07-20-2012, 02:58 AM
dilipandey Re: Date function that... 07-20-2012, 06:45 AM
  1. #1
    Registered User
    Join Date
    05-27-2012
    Location
    langkawi
    MS-Off Ver
    2007
    Posts
    46

    Date function that compare 2 date in single column and return value

    Hi

    How to write simple date function that will compare 2 date in single column and then will return statement "write off" or "still use" if it meet the condition

    example

    Column A Column B
    12/07/2005 Write Off
    12/07/2012 still use



    from example if in date column a is more than the today date, it will automatic show in column B write off else if less than today it will show still in use. This date comparison is to check if the date at column A is more than 2 years or less. This is for inventory system that see if the item is more than or reach 2 years, it will show write off or if less than 2 years, it will show still use


    thanks
    abu
    Last edited by alimamak; 07-19-2012 at 11:06 PM.

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