ACCESS DATA SOURCE GET CURRENT DATE RSS

• • Reply
  

  Baiju EP

  Member

  176 Points

  423 Posts

  ACCESS DATA SOURCE GET CURRENT DATE

  Dec 09, 2012 12:58 PM|LINK

  I USED THIS CODE IN SQL

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

  WHAT CAN BE USED IN ACCESS DATA SOURCE

  • Edited by Baiju EP on Dec 09, 2012 01:06 PM
  • Edited by Baiju EP on Dec 09, 2012 01:23 PM
• • Reply
  

  Baiju EP

  Member

  176 Points

  423 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 09, 2012 01:05 PM|LINK

  I tried IT BY USING THI S

  [from]-NOW()/30 AS TEN

  i want the out put in months

  • Edited by Baiju EP on Dec 09, 2012 01:06 PM
  • Edited by Baiju EP on Dec 09, 2012 01:06 PM
  • Edited by Baiju EP on Dec 09, 2012 01:20 PM
  • Edited by Baiju EP on Dec 09, 2012 01:21 PM
  • Edited by Baiju EP on Dec 09, 2012 01:21 PM
  • Edited by Baiju EP on Dec 09, 2012 01:24 PM
• • Reply
  

  Baiju EP

  Member

  176 Points

  423 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 09, 2012 01:24 PM|LINK

  when i used this code

  DATEDIFF(DAY, [from], date())/30 AS TEN

  the error is 

  No value given for one or more required parameters.

  <div>
  </div>

• • Reply
  

  Dan Bracuk

  Contributor

  3970 Points

  1096 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 09, 2012 01:34 PM|LINK

  Baiju EP

  when i used this code

  DATEDIFF(DAY, [from], date())/30 AS TEN

  the error is 

  No value given for one or more required parameters.

  <div>
  </div>

  Why did you switch from now() to date()?  Does date() take a parameter?  I can look it up, but so can you.

• • Reply
  

  oned_gk

  All-Star

  31523 Points

  6437 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 09, 2012 01:41 PM|LINK

  use hiddenfield as control param. Set the value in page load event. Hiddenfield1.value=now.date()
  Programming to simplify, dont look for hard way
• • Reply
  

  Baiju EP

  Member

  176 Points

  423 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 09, 2012 02:22 PM|LINK

  how can i add to access data source

• • Reply
  

  hans_v

  All-Star

  35986 Points

  6550 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 09, 2012 03:15 PM|LINK

  Baiju EP

  WHAT CAN BE USED IN ACCESS DATA SOURCE

  As already said, Now() is the equivalent of GETDATE() in SQL Server

  Baiju EP

  when i used this code

  DATEDIFF(DAY, [from], date())/30 AS TEN

  the error is 

  No value given for one or more required parameters.

  Because day is a reserved word (just like from) in Jet. But in Access (jet), the interval parameter is a string

  DATEDIFF('d', [from], date())/30 AS TEN

  http://www.techonthenet.com/access/functions/date/datediff.php

  • Edited by hans_v on Dec 09, 2012 03:16 PM
• • Reply
  

  Baiju EP

  Member

  176 Points

  423 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 09, 2012 03:55 PM|LINK

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

• • Reply
  

  hans_v

  All-Star

  35986 Points

  6550 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 09, 2012 09:48 PM|LINK

  Baiju EP

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

  What do you mean?

• • Reply
  

  oned_gk

  All-Star

  31523 Points

  6437 Posts

  Re: ACCESS DATA SOURCE GET CURRENT DATE

  Dec 10, 2012 12:06 AM|LINK

  try this

  datediff('d', [from], NOW()) / 30 AS TEN

  simiilar with your DATEDIFF(DAY, from, GETDATE())/30 AS TEN
  This will working

  Programming to simplify, dont look for hard way
  • Edited by oned_gk on Dec 10, 2012 12:09 AM
  • Edited by oned_gk on Dec 10, 2012 12:10 AM
  • Edited by oned_gk on Dec 10, 2012 01:54 AM