HOW TO SHOW THE DATA IF THE PRINTED DATE IS NULL

[553177]

HI,to all
I'm trying to pull data into a report and right now i'm only pulling data that was printed on the current date.
but customer order have a lot of work order that has not been printed. but i want to show does work orders
{WORK_ORDER.PRINTED_DATE} = Today and
{CUSTOMER_ORDER.STATUS} = "H"

 

[SkipVought]

Hi,

Try to figure out everything that DIDN'T happen today, rather than those things that you know happened??? You might run out of memory.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[AndersonCJA]

I'm not sure I understand so I apologize if my reply is not helpful.
How are you currently pulling data for the current date?
Are you asking how to print work orders on a specific date that is not the current date?
If so, you could try Date({WORK_ORDER.PRINTED_DATE}) = Date(2016,07,27)

 

[AndersonCJA]

If you want to print the record when {WORK_ORDER.PRINTED_DATE} is null you could try,
( isnull({WORK_ORDER.PRINTED_DATE}) or Date({WORK_ORDER.PRINTED_DATE}) = date(0,0,0) )