kigmaker

Can a global variable be used with the Extend function?

Discussion created by kigmaker on Feb 15, 2017
Latest reply on Feb 15, 2017 by kigmaker

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

Outcomes