Skip to Content
0

How to add Date and value in Crystal report 8.5

Jan 05, 2017 at 04:05 PM

42

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Don Williams
Jan 05, 2017 at 04:06 PM
0

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

Don

Share
10 |10000 characters needed characters left characters exceeded
Brian Dong Jan 05, 2017 at 05:45 PM
0

Hi Prabhu,

You can do this like:

{table.DATEFIELD} + 20; 

This will add 20 days to your date.

Brian

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 06, 2017 at 04:04 PM
0

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


pop-up.png (9.5 kB)
Show 1 Share
10 |10000 characters needed characters left 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

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

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

Share
10 |10000 characters needed characters left characters exceeded