Skip to Content
avatar image
Former Member

How to add Date and value in Crystal report 8.5

Hi

For ex:- Date is 10-nov-2016

value is 20 days

I need to add date + days = Solution should be 30-Nov-2016

Please help me on this

Thanks,

Prabhu P

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 05, 2017 at 04:06 PM

    Try searching first and if nothing found click the F1 key and open the local help file and search on Date

    Don

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2017 at 05:45 PM

    Hi Prabhu,

    You can do this like:

    {table.DATEFIELD} + 20; 

    This will add 20 days to your date.

    Brian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2017 at 04:04 PM

    pop-up.png

    Thanks to Don and Brian

    I have tried as below

    {xsw_vr05600.OrderDate}={xsw_vr05600.OrderDate}+30

    but while saving showing pop us as "The saved data is incomplete.Generate the data to save? "

    Please help me for this

    Thanks,

    Prabhu P

    Add comment
    10|10000 characters needed characters exceeded

    • This has nothing to do with the formula. It just means that you're saving the report with data (not necessarily a good idea - you can turn it off either on the File menu or in Report Options on the File menu) and you haven't run all of the data for the report.

      -Dell

  • avatar image
    Former Member
    Jan 16, 2017 at 02:32 PM

    Ok friend...

    Please help me to add date fields :(

    I have to add my order date + 10 days - i need my result in Date format

    Eg: Order date as 15/01/2017 and validity days as 10 ..so i need result as 25/01/2017

    Please friends ,am waiting for your replies.

    Regards,

    Prabhu

    Add comment
    10|10000 characters needed characters exceeded