Results 1 to 2 of 2

Thread: Date Range on Formula Fields

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2006
    Posts
    1

    Date Range on Formula Fields

    Hello guys
    I have a formula fields {STOCKWH.COUNT_DATE}+ 365
    that bring date value like (01/01/2007), and I need to have date range pulling those value (Parameter Fields)

    any Idea...?

    Please help...............

    thanks

  2. #2
    Addicted Member craigreilly's Avatar
    Join Date
    Jul 2004
    Location
    Scottsdale, AZ
    Posts
    188

    Re: Date Range on Formula Fields

    VB Code:
    1. dim year, month, day as integer
    2.  
    3. 'Put code here to get your integers
    4.  
    5. report.RecordSelectionFormula = "{STOCKWH.COUNT_DATE}=Date (year, month, day)"

    I am sure you can figure out how to get the "new" date to plug into the formula.
    Last edited by craigreilly; Jun 2nd, 2006 at 06:59 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width