Print Page | Close Window

Date formula (each day), 2010 -> run date

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21668
Printed Date: 27 Apr 2024 at 5:33pm


Topic: Date formula (each day), 2010 -> run date
Posted By: Dangoo
Subject: Date formula (each day), 2010 -> run date
Date Posted: 01 Sep 2015 at 9:50pm
Hello,

I need a formula where I can hypothetically place into a blank report in the details section where it will bring up every single date by day ever (obviously this will be restricted by a parameter).

If a starting date is required then 2010 should be early enough, however I need it to carry on until all eternity or at least until the day the report is ran.


example being:

---
01/01/2010
---
02/01/2010
---
dd/mm/yyyy..., etc.
---

Many thanks in advance!

Daniel


Replies:
Posted By: Dangoo
Date Posted: 01 Sep 2015 at 11:50pm
I found this formula from http://scn.sap.com/community/crystal-reports/blog/2011/12/13/displaying-all-missing-dates-in-a-range--a-custom-function-sample , which I think is the answer.

Posted By: lockwelle
Date Posted: 03 Sep 2015 at 6:17am
Just as an aside then, or an alternative solution...

Typically, to get all the dates, you would need a command or a datatable to select all the dates and then join to that (probably as an outer join) for the display in your report.

Posted By: Dangoo
Date Posted: 07 Sep 2015 at 12:51am
Originally posted by lockwelle

Just as an aside then, or an alternative solution...

Typically, to get all the dates, you would need a command or a datatable to select all the dates and then join to that (probably as an outer join) for the display in your report.


I unfortunately do not have a data table in my ERP database. How would I use a command to bring the dates in?

Unfortunately, the solution that i thought i found was only half good. It managed to bring in the intermediate dates however they were pulled in as big block and not as individual entries as desired. as seen in the below link

http://imgur.com/upncBhO


Print Page | Close Window