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!

  • Congratulations gkittelson 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. cloudstrifer

    Datevar Array not working

    Hi Clarliy, When I use the formula, it doesn't add an extra day or two if the holiday lands on a weekday or weekend. Basically, the whole field is blank when I use the formula above. however, when I use the formula below it works fine but I will need to modify it each year //check for weekend...
  2. cloudstrifer

    Datevar Array not working

    Hi, My following formula does not work and I don't have a clue why. I try to create a datevar array with values coming from sql expressions. Please help DateVar Array holidays := [date({%CANADA DAY}), date({%CHRISTMAS DAY}), date({%CIVIC HOLIDAY}), date({%GOOD FRIDAY}), date({%LABOUR DAY})...

Part and Inventory Search

Back
Top