2 Replies Latest reply on Feb 15, 2017 4:00 PM by G T

    Can a global variable be used with the Extend function?

    G T

      Hello Folks,

       

      Is it possible to use a global variable rather than a global field with the Extend function?

       

      The calculation is below.

      Can $$projectDateQuery be used in place of GLOBAL::PROJECT_DATEQUERY.

       

      Let ( [

      _dateCurrent = Extend ( GLOBAL::PROJECT_DATEQUERY ) + Get ( CalculationRepetitionNumber ) ;

      _dateDue = Extend ( projects_PROLINES::dateDue ) ;

      _dateStart = Extend ( projects_PROLINES::dateStart ) ;

      _dateEnd = Extend ( projects_PROLINES::dateEnd ) ;

      _status = Extend ( projects_PROLINES::Status )

      ] ;

      Case (

      _dateCurrent > _dateStart and _dateCurrent < _dateEnd + 2; _status ;

      _dateCurrent = _dateStart + 1 ; _status

      )

      )

       

      Thanks for any help.

       

      Greg