ACCESS DATA SOURCE GET CURRENT DATE RSS

• • Reply
  

  Baiju EP

  Member

  178 Points

  439 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 14, 2012 03:31 PM|LINK

  DEAR  oned_gk I TRIED YOUT=R TRICK AND GOT IT

  CODE I USED IS AS UNDER

  SELECT PersData.PNO, PersData.RANK, PersData.Name, PersData.DOSEN, PersData.UNIT, PersData.APPOINTMENT,PersData.FROM, PersData.SPECI,PersData.COURSESTR,DateDiff('d', [PersData.FROM], Now()) / 30 AS TEN
  FROM PersData

  AND IN GRIDVIEW USED DataFormatString={0:f0} FOR REMOVING DECIMALS

  • Edited by Baiju EP on Dec 14, 2012 03:32 PM
  • Edited by Baiju EP on Dec 14, 2012 03:33 PM
  • Edited by decker dong - msft on Dec 15, 2012 01:04 AM
  • Marked as answer by decker dong - msft on Dec 15, 2012 01:04 AM
• • Reply
  

  hans_v

  All-Star

  35998 Points

  6551 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 14, 2012 04:29 PM|LINK

  Baiju EP

  CODE I USED IS AS UNDER

  SELECT PersData.PNO, PersData.RANK, PersData.Name, PersData.DOSEN, PersData.UNIT, PersData.APPOINTMENT,PersData.FROM, PersData.SPECI,PersData.COURSESTR,DateDiff('d', [PersData.FROM], Now()) / 30 AS TEN
  FROM PersData

  which is exactly the same as:

  SELECT PNO, RANK, Name, DOSEN, UNIT, APPOINTMENT,[FROM], SPECI,COURSESTR,DateDiff('d', [FROM], Now()) / 30 AS TEN
   FROM PersData

  
   

  • Marked as answer by decker dong - msft on Dec 15, 2012 01:04 AM