ACCESS DATA SOURCE GET CURRENT DATE RSS

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 10, 2012 01:30 AM|LINK

  Baiju EP

  TRIED THE SCRIPT IN GRID VIW TEN FIELD DISPLAYS dd/MM/yyyy AND NOT THE MONTH

  Hi again,

  Hans_v says right——Please refer this rule:

  The syntax for the DateDiff function is:

  DateDiff ( interval, date1, date2, [firstdayofweek], [firstweekofyear])

  interval is the interval of time to use to calculate the difference between date1 and date2. Below is a list of valid interval values.

  Interval	Explanation
  yyyy	Year
  q	Quarter
  m	Month
  y	Day of year
  d	Day
  w	Weekday
  ww	Week
  h	Hour
  n	Minute
  s	Second

  And what's more, can you show us how you write your query string of SQL in Access?

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 10, 2012 01:32 AM|LINK

  Baiju EP

  TRIED THE SCRIPT IN GRID VIW TEN FIELD DISPLAYS dd/MM/yyyy AND NOT THE MONTH

  Hello again,

  If you wanna see the differences between the two date and get the Month, please try this:

  DateDiff ("m", date1, date2)

• • Reply
  

  Baiju EP

  Member

  176 Points

  419 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 10, 2012 01:47 PM|LINK

  THERE IS NO ERROR BUT THE COLOUMN TEN SHOWS 

  dd/MM/yyyy

   NO NUMERICALS

  IN MY TABLE FROM IS A DATE

• • Reply
  

  Baiju EP

  Member

  176 Points

  419 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 10, 2012 01:49 PM|LINK

  I WANT THE DATE DIFFRENCE IN MONTHS (EG FROM AMD TO TODAY/30) IT WILL SHOW HOW MANY MONTHS. THAT IS WHAT I WAS LOOKINH

• • Reply
  

  oned_gk

  All-Star

  31257 Points

  6389 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 10, 2012 01:56 PM|LINK

  datediff('m', [from], NOW()) AS TEN

  Programming to simplify, dont look for hard way
• • Reply
  

  Baiju EP

  Member

  176 Points

  419 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 10, 2012 03:39 PM|LINK

  NOT WORKING

  MY CODE IS AS UNDER

  SELECT [PNO],[RANK], [Name], [DOSEN], [UNIT],[APPOINTMENT],[FROM],[SPECI],Coursestr,
  datediff('m', [from], NOW()) AS TEN FROM [PersData]WHERE SPECI='COMD'"

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 11, 2012 12:04 AM|LINK

  Baiju EP

  NOT WORKING

  Show us your screenshot, please

• • Reply
  

  Baiju EP

  Member

  176 Points

  419 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 11, 2012 04:04 PM|LINK

   my screen shot is here

  • Edited by Baiju EP on Dec 12, 2012 12:35 AM
• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 12, 2012 09:32 AM|LINK

  Baiju EP

  Baiju EP

  I cannot see that image, please submit this to the skydrive and them paste the relative url.

• • Reply
  

  Baiju EP

  Member

  176 Points

  419 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 12, 2012 01:52 PM|LINK

  i had shared it in 4shared.com i had uploaded in skydrive but not able to share

  http://www.4shared.com/photo/8w__dF-b/screen.html

  code use is abelow

  SELECT [PNO],[RANK], [Name], [DOSEN], [UNIT],[APPOINTMENT],[FROM],[SPECI],Coursestr,
  datediff('D', [from], NOW()) AS TEN FROM [PersData]WHERE SPECI='COMD'