User Profile

Collapse

Profile Sidebar

Collapse
musab hosawy
musab hosawy
Last Activity: Feb 23 '12, 08:27 PM
Joined: Feb 12 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • musab hosawy
    replied to calculate the contract end remaining days
    in Access
    will i use this DateDiff("m";Da te();date_end )& "monthe"

    but its only give me the monthe i whant the days ,monthe, years

    i need to Calculate difference between 2 dates in years months and remaining days
    See more | Go to post

      Leave a comment:

    • musab hosawy
      started a topic calculate the contract end remaining days
      in Access

      calculate the contract end remaining days

      i need to calculate the days left for a contract to end

      i have a table contain the (start_cont) and from the query

      i calculated the (end_cont)

      end_cont=( DateAdd("d";-1;DateAdd("yyyy ";3;[tbcontract]!
      [start_day])).

      now i whant to calculate the days left before the contract

      end (ex= 2 days 3 monthe 2 years)in this format

      pleas hlp accesss...
      See more | Go to post
      No activity results to display
      Show More
      Working...