ACCESS DATA SOURCE GET CURRENT DATE RSS

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 13, 2012 12:08 AM|LINK

  Baiju EP

  Baiju EP

  Hi again,

  You mean your "Ten" column is still of "dd/MM/yy"?

• • Reply
  

  Baiju EP

  Member

  176 Points

  424 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 13, 2012 01:04 AM|LINK

  yes

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 13, 2012 04:16 AM|LINK

  Baiju EP

  yes

  What codes have you written?

• • Reply
  

  oned_gk

  All-Star

  31595 Points

  6454 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 13, 2012 06:08 AM|LINK

  What is your [from] datatype?

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

  Baiju EP

  Member

  176 Points

  424 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 13, 2012 02:48 PM|LINK

  this is my code

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

  
  
  

• • Reply
  

  Baiju EP

  Member

  176 Points

  424 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 13, 2012 02:50 PM|LINK

  Dear oned_gk

  My FROM field i s a Date/Time

• • Reply
  

  hans_v

  All-Star

  35986 Points

  6550 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 13, 2012 05:34 PM|LINK

  Baiju EP

  NOT WORKING

  What do you mean by "Not working'?

  Your SQL string looks ok, but the ASP.NET qrystal ball isn't working, so if you don't tell us your desired result, perhaps with some sample data and desired output, we need to guess what you want?

• • Reply
  

  Baiju EP

  Member

  176 Points

  424 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 14, 2012 12:49 AM|LINK

  DATABASE IS IN MS ACCESS

  TABLE NAMED PersData

  PNO RANK Name DOSEN UNIT APPOINTMENT FROM SPECI Coursestr

  1234 LDC KING 12/21/1999 1 HOSP DOCTOR(SUR) 9/19/2009 PH1 MBBS,SUR SPL

  2134 UDC JOHN 04/23/2001 2 HOSP ASST 1 12/31/2009 PH2 LAB TECH 

  1235 LDC PAL 12/21/1999 1 HOSP DIR 9/19/2009 PH1 MBBS,MD

  2154 UDC SIOM 04/23/2001 2 HOSP CLK 1 12/31/2009 PH2 MA

  QUERY I USED FOR THIS TABLE ABOVE IS 

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

  I WANT TO CALCULATE AND DISPLAY HOW MUCH MONTH DID EACH STAFF SERVED IN TEN COLOUMN

  IN MY SQL DATATABE I USED THE FOLLOWING AND GETS CORRECT RESULT IN MONTHS

  DATEDIFF(DAY, FROM, GETDATE())/30 AS TEN

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

  hans_v

  All-Star

  35986 Points

  6550 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 14, 2012 10:54 AM|LINK

  Baiju EP

  I WANT TO CALCULATE AND DISPLAY HOW MUCH MONTH DID EACH STAFF SERVED IN TEN COLOUMN

  I don't think I understand, but....

  Baiju EP

  IN MY SQL DATATABE I USED THE FOLLOWING AND GETS CORRECT RESULT IN MONTHS

  DATEDIFF(DAY, FROM, GETDATE())/30 AS TEN

  As already said, the equivalent of this in Access is:

  DateDiff('d', [FROM], Now()) / 30 AS TEN

• • Reply
  

  oned_gk

  All-Star

  31595 Points

  6454 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 14, 2012 11:07 AM|LINK

  open your db using ms access. Try some query there. There is litle bit deferent SQL command between SQL in ms access and SQL in SQL Server.
  Programming to simplify, dont look for hard way
  • Marked as answer by Baiju EP on Dec 14, 2012 03:32 PM