record Formula

[EngJoo]

greetings,
i would like to seek yours help on create formula the selection the row field.

in my report, i choose date from A to B as select expert.

so my report preview is

cust_no date unit
1234 06-may-2002 1
1111 11-may-2002 0


so i would like to set a formula in column field(unit) such that:-

if date = 06-may-2002 fall in between date A and B
then 1 else 0.

i just know the logic but doesnt know the correct way to write good selection formula. please advise

i know there is one way that can perform what i want which is

if {date} from (A) to (B) then 1 else 0

but i got to change it manually when i changed the select expert.

i thinking of to do in such a way that

if {date}=06-may-2002 is true then 1 else 0

please let me know is CR cannot do in that way
i am using CR8.0

i hope my explaination will not confuse you.
hope can hope from yours soon.

thank you in advance

 

[mlmcc]

Try something like this
{invdate}>= Date(2002,05,08) and {invdate} <= Date(2002,05,10)

mlmcc

 

[EngJoo]

i know its works in that way.but i have many column.so if i change the selection date then i need to change the date applied on the each column.
my concern is when i change the selection date
then the column will detect then they will change it as well instead of i change it manually.
please advice from all of you.
thank you again for your response.