function basics

[steeleydon]

Newbie question.

I am trying to use the case function to select data from one field if before a certain date, and another after the date.

I have used the following, but it behaves as though its not interpreting the date correctly. When I try the same with If, a similar thing happens. I am using an old database in fp5 for this.

case(visit date > 6/30/2004, related field 1, visit date <= 6/30/2004, related field 2)

thanks for the help.

dcs

[RalphL]

Try using: case(visit date > Date(6,30,2004), related field 1, related field 2)

Also make sure that visit date is a date field, and related field 1, related field 2 and the calculation field are the same data type.

[steeleydon]

works perfect.

much thanks, I searched all over for the answer x hrs, and tried multiple variations...

really appreciate it.

dcs