Announcement

Collapse
No announcement yet.

Formula for calculating today's date

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Formula for calculating today's date

    Hi all,

    Many of our reports are run weekly or monthly to present data for specific period of time. This selection criteria picks up a specified range of source codes but I still have to enter the date range when I run the report.
    Code:
    tblAccounts.AccountSource >= 'LP'
        and
    tblAccounts.AccountSource <= 'LZ'
        and
    tblAccounts.sourcechangeddate >= '<&From Source Date>'
        and
    tblAccounts.sourcechangeddate <= '<&Thru Source Date>' + ' 11:59:59 PM'
    I want to hard code something like this:
    Code:
    tblAccounts.sourcechangeddate >= TODAY - 7 DAYS
        and
    tblAccounts.sourcechangeddate <= TODAY + ' 11:59:59 PM'
    Also this:
    Code:
    tblAccounts.sourcechangeddate >= FIRST DAY OF LAST MONTH
        and
    tblAccounts.sourcechangeddate <= LAST DAY OF LAST MONTH + ' 11:59:59 PM'
    Is this possible?

    Thanks in anticipation.
    Trish @ ITA

  • #2
    Customizing Crystal reports is not covered under thestandard user agreement but Tigerpaw does have custom report writers on staff.Please contact your account manager for pricing information.
    — Loren Albright
    Data Engineer, Tigerpaw
    » » Connect with Tigerpaw: Twitter, Facebook, LinkedIn

    Comment


    • #3
      Trish, You might want to check out the Tantivy package at www.Tigertrak.net .

      Comment

      Working...
      X