Sage 100

 View Only

  • 1.  Conditional Import based on Hire Date

    Posted 05-13-2023 12:37

    I am trying to import into the  TimeOff Schedule but based on the Hire Date.  How do I format the condition for the Date to be less than another date?? I can only find based on today.



    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------


  • 2.  RE: Conditional Import based on Hire Date

    Posted 05-13-2023 14:32

    I believe this format works  

    {d '2015-07-28'}



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: Conditional Import based on Hire Date

    Posted 05-13-2023 14:51

    I guess nope....  



    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------

    Original Message


  • 4.  RE: Conditional Import based on Hire Date

    Posted 05-15-2023 07:53

     

    Lourdes,

     

    Try this (I used today's date)

     

    DTE({PR_Employee.HireDate$:"YYYYMMDD")}< DTE("20230515":"YYYYMMDD")

    OR MAYBE JUST

    {PR_Employee.HireDate$)< DTE("20230515":"YYYYMMDD")

     

     

     

     

    UPCOMING SESSIONS THAT MAY INTEREST YOU:

    AP Automation for Sage 100 Demo: View the details

    Don't miss the 2023 Basic Crystal Reports for Sage 100 Online Training: View the details

    Don't miss the 2023 Intermediate Crystal Reports for Sage 100 Online Training: View the details

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    260.399.8655 Direct

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

     




    Original Message


Related Content