urgent Formula

[fhurmuzlu]

I have WEDATE Table which has a field called WKEND , I need to read the table and print Weekend dates for a month.please I need help. by the way the table is string but it is Date table.

 

[kskid]

I use Crystal 8.5 using an Oracle database via ODBC connection.

Try this

DayOfWeek({table.date}) in [1,7]

Without more technical information, not sure if this is enouogh. See FAQ149-3762

 

[kskid]

Missed a piece

It would help if you gave the layout format of the date string.

Depending on the format, such as MMDDYYYY, create the following formula, WKEND

//@WKEND - Change string date to actual date
numbervar d := tonumber(left({WEDATE.WKEND},2));
numbervar m := tonumber(mid({WEDATE.WKEND},3,2));
numbervar y := tonumber(right({WEDATE.WKEND},4));

date(y,m,d)

In record selection, add the following to get the weekend dates

DayofWeek({@WKEND}) in [1,7]

-LW