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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Gupta Report Builder 6.0 QRP

Status
Not open for further replies.
StacyDOW

StacyDOW

Technical User
Jan 30, 2018
1
US
I am new to Report Builder 6.0. I have a qrp file I'd like to modify a DueDate field on that report so if that DueDate field value is null it would insert today's date instead. DueDate is a date/time field.

I'm confused between adding a condition on that field and just creating a new formula field. I can't seem to get the syntax correct. I've tried something like this
DateIFF( StrLength( StrTrim(DateToStr( DUEDATE )) ) , DATE_NULL , TODAY() , DUEDATE )

Any help you can provide would be much appreciated!

Thank you

 
Status
Not open for further replies.

Similar threads

BTrees
  • Locked
  • Question
Microsoft Reporting Services in Visual Studio-Add datasets through script
Replies
0
Views
68
BTrees
BTrees
arrt
  • Locked
  • Question
What UserName and Password I need for Report Builder?
Replies
0
Views
34
arrt
arrt
kjv1611
  • Locked
  • Question
SQL Server Reporting Services - Report Builder 3.0 - Somewhat Dynamic Parameters (Date Options)
Replies
2
Views
58
philhege
philhege
codrutza
  • Locked
  • Question
Report with Subreport Min Date Live Tables 1
Replies
10
Views
68
Olaf Doschke
Olaf Doschke
codrutza
  • Locked
  • Question
It Works on SQL Server But Slow for Report
Replies
3
Views
53
codrutza
codrutza

Part and Inventory Search

Sponsor

Back
Top