Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Shanna

    Wildcards in date

    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...
  2. Shanna

    WorkDays Formua returning zero values

    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...
  3. Shanna

    WorkDays Formua returning zero values

    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...
  4. Shanna

    Error Message in Work Days Formula

    Yes, thanks, thats exactly it.
  5. Shanna

    Error Message in Work Days Formula

    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...
  6. Shanna

    Leap Year in Crystal

    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

Part and Inventory Search

Back
Top