CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: Nepboard

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    2,583

    Date Formula Issue

    Hello,
    For years I have been using the CDate({trips.tdate}) = dateadd('d',-1 ,CurrentDate ) to batch print reports automatically utilizing Crystal Delivery. There has been changes to the report so...
  2. Replies
    2
    Views
    558

    33 days from invoiced date

    When we print invoices, we offer a 25% discount if they pay within 33 days from the date of invoice. Can anyone help with a formula that would show the date 33 days from printed invoice date? As...
  3. Thread: Average

    by Nepboard
    Replies
    0
    Views
    542

    Average

    I have the formula below that gives me the difference between the at destination time and created time. There may be cases were there are multiple times. I want to average the time result. As always,...
  4. Replies
    1
    Views
    559

    Time Difference

    I have an at destination time (FDC_Trips.atdtime) and a created time (FDC_trip_Packages.createdtime). I want to know the difference between the at destination time and the created time. I was looking...
  5. Replies
    1
    Views
    1,207

    Noon to midnight formula help

    I'm trying to write a custom formula to only show records that happened between noon and midnight over a specific date range. I have no problem with the date range but the time thing is killing me....
  6. Replies
    0
    Views
    418

    Supressing unwanted data

    Can anyone help me with the formula to suppress unwanted data in Crystal 10? Using the formula below I get the calls when a 12lead was not done, but I still get all of the other interventions...
  7. Replies
    3
    Views
    726

    Re: Yesterday and the Day Before

    As before, Thanks alot!
  8. Replies
    3
    Views
    726

    Yesterday and the Day Before

    With great help from this forum I have the function below that gives me yesterdays information. If I wanted yesterday and the day before what changes would be made in the function. I have tore apart...
  9. Replies
    2
    Views
    567

    Re: Problem with Crystal report

    If you open and save a report in versions 9 on up, you will not be able to open it in earlier versions. Copy it, rename it, and use that copy in the newer version.
  10. Replies
    11
    Views
    1,173

    Re: Function for "yesterday"

    Thanks JaganEllis!
  11. Replies
    11
    Views
    1,173

    Re: Function for "yesterday"

    I got it, I got it!!!! Thanks everyone!!!!!!
  12. Replies
    11
    Views
    1,173

    Re: Function for "yesterday"

    You are correct in the fact it is a string. I have no way of changing how the software captures the date. I pasted the following

    CDate({trip.tdate}) = dateadd('d',-1 ,CurrentDate )

    It now tells...
  13. Replies
    11
    Views
    1,173

    Re: Function for "yesterday"

    This is what I have
    {Trips.tdate} = dateadd('d',-1 ,CurrentDate )

    I get a "number amount, currency amount, boolean or sting is expected here" Here being between the = and dateadd

    I know now...
  14. Replies
    11
    Views
    1,173

    Re: Function for "yesterday"

    I am getting an error stating "a string is required". It follows the =
  15. Replies
    11
    Views
    1,173

    Re: Function for "yesterday"

    The database field that I pull the date from is the {Trips.tdate}, therefor it would be this?

    {Trips.tdate} dateadd('d',-1 ,CurrentDate )
  16. Replies
    11
    Views
    1,173

    Function for "yesterday"

    Can anyone help with the function for reporting the day before current date? I'm using Crystal 10. Being new to Crystal I can't seem to get the formula to work that I have. I want the report that I...
Results 1 to 16 of 16


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)