This is my first post, so hello to you all.

 

I've been given the task of report writing for our new ERP system which runs on a SQL server.  I've not report writing experience, had one days training and Brian Bischof's book for support.

 

One of the reports I need is a report that only shows where no promise date has been entered so field should contain no data

 

How can I select the records that have no date, I've tried entering a value of 00/00/00 but it errors out saying that a date and time is required here if I enter 00/00/00 00:00:000 it reports 'The remaining text does not appear to be part of the formula.

 

Can anybody help, as I've had no experience with formulas at all.

 

Thanks in advance

 

Bodie

 

could be you are missing quotes, I used this and it seems to work fine:

if {params.OneEntryPage} then
    "00/00/0000 00:00:00"
else
    now()

 

hopefully between DBlank and me, you have a solution that works for your data.

 

Cheers