I need a formula for my date ranges.

[skreczko]

Hello Crystal Reports Gods,
I would like to have a formula that filters out all the dates(DC:REC) that are older them 6/01/10 but also keep the blank records? Does anyone know how to write that formula.
Thanks for the help

Sample of my data
Loan ID………..DC:REC
134560…………8/01/10
F34556………..07/06/10
3f45567……….04/27/10
M876543……..9/25/10
2456g42……..10/10/10
M532135……..12/01/09
P325a3n……….8/20/07
342942n……….Blank
P024521……….6/15/10

 

[Madawc]

Something like

Isnull({your.field}) or
{your.field} = " "
or Date({your.field}) >= Date(2010, 1, 6)

Best write it and display it beside unselected data, to check it does what you want. (I assume you mean 6th January but it could be 1st June, and anyway it might be better to use DateAdd to make it a difference from the current date.)

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[skreczko]

thnaks for the help.
Its June 1st

Isnull({Command.DC:REC}) or
{Command.DC:REC} = " "
or Date({Command.DC:REC}) >= Date(2010, 6, 1)
I get an error saying that a date and time is required here highlighting the " ".
Am I supost to add something here

 

[lbass]

Isnull({Command.DC:REC}) or
Date({Command.DC:REC}) >= Date(2010, 6, 1)

-LB