Search results for query: *

Hi all, Is there a way of incoprporating a wildcard into a date? For example, using the datre formula (where the asterix * is the wildcard) : If month (start) = Date (year(CurrentDate),2,*) I need to calculate the current year, month 2, but any day within that month. Does anyone have a...

Hi Ken, thanks for getting back. Okay... This is what I'm trying to do: The above formula was for absence in January. I trying to work out each instance of absence in each month (the formula above is for January only) for each employee. I am going to repeat the formula above and create...

Hi there, I hve altered Ken's working days formula (thanks Ken!) to suit my report however instead of returning the absence days as required, I am getting zero vaules returned and I can't see why.. as usual, any help much appreciated, formula attached below: numberVar TotalAbs; DateVar Begin...

Yes, thanks, thats exactly it.

Hi Everyone, When I am checking the formula below in Crystal, I am encountering the following error ' A number, currency amount, boolean, or string is expected here' (at the point marked ***this is where the error is occuring**** in the formula below - just before the DaysOfWeek in the...

Hi there.. Im absolutely flummoxed by this one. What I need to do is work out is absent days lost taking into account leap years AND weekdays only. Can anyone help at all ? If so, this wee Scots lass will be forever in your debt! Shanna