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 strongm 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: *

  • Users: Tuch
  • Order by date
  1. Tuch

    Group Every 2 Weeks

    Ok, I actually fixed it ! Yeah. Thanks again.
  2. Tuch

    Group Every 2 Weeks

    Forgive me for not knowing this...how does my data in the detail section change to the correct pay cycle. It's still off a week.
  3. Tuch

    Group Every 2 Weeks

    Sorry, first time posting to Tek-Tips. I read the post all the time for help. Here's the formula I used in Change Group Options: if remainder(datepart("ww",{VP_ACCRUALTRANV42.EFFECTIVEDATE}),2) = 0 then {VP_ACCRUALTRANV42.EFFECTIVEDATE}-dayofweek({VP_ACCRUALTRANV42.EFFECTIVEDATE})+7 else...
  4. Tuch

    Group Every 2 Weeks

    I tried using the formula you suggested for ternas1, however, it's giving me an error : The formula result must be a string. I tried using ToText and nothing seems to be working. Could you please help. Thanks.

Part and Inventory Search

Back
Top