Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding a field that displays the date of the previous Friday

Status
Not open for further replies.
t16turbo

t16turbo

Programmer
Mar 22, 2005
315
GB
Hi guys,

I ahve created a report that has three sections (each with its own SQL)

I want to display a date underneath the report title in the page layout section.
the date is that of the previous friday (in SQL it would be SELECT Next_Day(SYSDATE - 8,'Friday'))

is it possible to put this in underneath the report title in the Page LIst section?

failing that, how can I add a single field with a date calculation/query?
 
Status
Not open for further replies.

Similar threads

KwabenaKissi
  • Locked
  • Question
Actuate 8 basic Error 2
Replies
0
Views
190
KwabenaKissi
KwabenaKissi
dlangschied
  • Locked
  • Question
Adding a table to the Query Editor
Replies
0
Views
146
dlangschied
dlangschied
Abouelela88
  • Locked
  • Question
How to get the maxuser / maximo username who requested the actuate report
Replies
0
Views
143
Abouelela88
Abouelela88
Abouelela88
  • Locked
  • Question
How can I pass the current (logged in) user as a report parameter?
Replies
0
Views
161
Abouelela88
Abouelela88
zain001
  • Locked
  • Question
Actuate 8 - Not able to run rox file. Basic error: 1011
Replies
0
Views
203
zain001
zain001

Part and Inventory Search

Sponsor

Back
Top