Hello

I've got two date fields for each record. On each record only one of them has a date in it. (Long story as to why)

I've got another field returning which week of the year it is (using the WeekofYear() function).

I can set up this field to look up either one or the other of the date fields, but how do I get it to look at both of them.

In other words I want it to look at field (a) and see if it's empty or has a date in it. If it has a date do the function, or else look in field (: for a date.

Thanks for your time

Drew

Just use the following:

Case(Date1 <> "", WeekofYear(Date1), WeekofYear(Date2))

You can just copy and paste this into your calculating field. Simply change Date1 & 2 to match your field names.

Cheers,

Rigsby

Thanks for that Rigsby, it works well.....drew