Hi all! I am trying to create a report with the timesheet end date. Unfortunately, because of the way we initially loaded the system, some of our data is missing a time sheet end date. So I am trying to use text mode to identify blank end dates and substitute a date of 9/30/2017. This is what I have now, but my report shows blank in this field: displayname=Week End Date linkedname=timesheet namekey=view.relatedcolumn namekeyargkey.0=timesheet namekeyargkey.1=endDate querysort=timesheet:endDate textmode=true valueexpression=IF(ISBLANK({timesheet:endDate}),"09/30/2017",{timesheet:endDate}) valuefield=timesheet:endDate valueformat=atDateWithOutTime Any help would be appreciated. Celeste Celeste DiDio PwC FL