formula needed for previous dates 3

[jedder18]

Looking for a simple formula to show all the days prior to current month...

TIA....

Jen

Jedder

 

[SkipVought]

That's a LOT of days! "All the days prior...

 

[briangriffin]

select min(calendardate) where HasBigBangOccurred = 'Y'

 

[pmax9999]

Are you saying you want the report to return records where a specific date field from your database is prior to the current month? There are several ways to do this. One way would be:

{Table.DateField} <= (CurrentDate - Day(CurrentDate))

, where {Table.DateField} should be replaced with the actual field from your database.

Hope this helps.

Cheers
Pete

 

[jedder18]

what I have is a report that counts a number of occurrences for an event.
That number needs to be added to occurrences that happened before that event.

I'm trying to get the prior wks to run correctly...given that the report has date parameters for current occur
I know I'll be using the current occur field added to prior wks field.


ex: prior wks occur current occur
wk1 30 10
wk2 40 5
wk3 45 and so on...

Thanks so much.






Jedder

 

[Charliy]

If I understand correctly, you need to do something like this:
If your Date Range parameter is a single ranged parameter, you need a formula that is Maximum({?Date Range}
If you have separate Begin and End dates, use the End Date parameter in place of the {@EndDate} formula.

In you select statement include: {table.date} <= {@EndDate}

Group on the Event ID
Put everything in the Group Footer, suppress Detail and Group Header.
Sort by date

In the Section Expert do a Conditional Suppress on the Group Footer that is like:
not( Maximum({table.date},{table.event}) in {?Date Range})