• For instance, you can use the FormatLabel property to customize the labels and the subdivisions in your chart as you can see in the following screen shot (  "'Group <b>'+int(1 +dvalue/16)" ):

If the Unit property is exDay for several levels ( more than 1 level ), you can display your subdivisions using the Count property, based on 0, not based on the FirstVisibleDate property. You can get this layout using the 

• Other sample would be, if you need to display the last Friday of each month using a different color, so in this case you can use the FormatLevel property as "(weekday(dvalue)=5 ? month(dvalue+7)!=month(dvalue) ? '<b><bgcolor=000000><fgcolor=FFFFFF>' ) + value" as in the following screen shot:

The screen shows in different colors  the Jun 27 as being the last Friday of June, and the Jul 25 as being the last Friday on July.

• The following screen shot shows the week end days using a different foreground color ( FormatLabel property is "weekday(dvalue)=6 ? '<fgcolor=D0D0D0>Sa' : ( weekday(dvalue)=0 ? '<fgcolor=D0D0D0>Su' : value )" ) 

The supported binary arithmetic operators are:

• * ( multiplicity operator ), priority 5
• / ( divide operator ), priority 5
• mod ( reminder operator ), priority 5
• + ( addition operator ), priority 4 ( concatenates two strings, if one of the operands is of string type )
• - ( subtraction operator ), priority 4

The supported unary boolean operators are:

• not ( not operator ), priority 3 ( high priority )

The supported binary boolean operators are:

• or ( or operator ), priority 2
• and ( or operator ), priority 1

The supported binary boolean operators, all these with the same priority 0, are :

• < ( less operator )
• <= ( less or equal operator )
• = ( equal operator )
• != ( not equal operator )
• >= ( greater or equal operator )
• > ( greater operator )

The supported ternary operators, all these with the same priority 0, are :

• ? ( Immediate If operator ), returns and executes one of two expressions, depending on the evaluation of an expression. The syntax for is 

"expression ? true_part : false_part"

, while it executes and returns the true_part if the expression is true, else it executes and returns the false_part. For instance, the "%0 = 1 ? 'One' : (%0 = 2 ? 'Two' : 'not found')" returns 'One' if the value is 1, 'Two' if the value is 2, and 'not found' for any other value. A n-ary equivalent operation is the case() statement, which is available in newer versions of the component.

The supported n-ary operators are (with priority 5):

• in (include operator), specifies whether an element is found in a set of constant elements. The in operator returns -1 ( True ) if the element is found, else 0 (false) is retrieved. The syntax for in operator is 

"expression in (c1,c2,c3,...cn)"

, where the c1, c2, ... are constant elements. The constant elements could be numeric, date or string expressions. For instance the "value in (11,22,33,44,13)" is equivalent with "(expression = 11) or (expression = 22) or (expression = 33) or (expression = 44) or (expression = 13)". The in operator is not a time consuming as the equivalent or version is, so when you have large number of constant elements it is recommended using the in operator. Shortly, if the collection of elements has 1000 elements the in operator could take up to 8 operations in order to find if an element fits the set, else if the or statement is used, it could take up to 1000 operations to check, so by far, the in operator could save time on finding elements within a collection.

• switch (switch operator), returns the value being found in the collection, or a predefined value if the element is not found (default). The syntax for switch operator is 

"expression switch (default,c1,c2,c3,...,cn)"

, where the c1, c2, ... are constant elements, and the default is a constant element being returned when the element is not found in the collection. The constant elements could be numeric, date or string expressions.  The equivalent syntax is "%0 = c 1 ? c 1 : ( %0 = c 2 ? c 2 : ( ... ? . : default) )". The switch operator is very similar with the in operator excepts that the first element in the switch is always returned by the statement if the element is not found,  while the returned value is the value itself instead -1. For instance, the "%0 switch ('not found',1,4,7,9,11)" gets 1, 4, 7, 9 or 11, or 'not found' for any other value. As the in operator the switch operator uses binary searches for fitting the element, so it is quicker that iif (immediate if operator) alterative.

• case() (case operator) returns and executes one of n expressions, depending on the evaluation of the expression ( IIF - immediate IF operator is a binary case() operator ). The syntax for case() operator is:

"expression case ([default : default_expression ; ] c1 : expression1 ; c2 : expression2 ; c3 : expression3 ;....)"

If the default part is missing, the case() operator returns the value of the expression if it is not found in the collection of cases ( c1, c2, ...). For instance, if the value of expression is not any of c1, c2, .... the default_expression is executed and returned. If the value of the expression is c1, then the case() operator executes and returns the expression1. The default, c1, c2, c3, ... must be constant elements as numbers, dates or strings. For instance, the "date(shortdate(value)) case (default:0 ; #1/1/2002#:1 ; #2/1/2002#:1; #4/1/2002#:1; #5/1/2002#:1)" indicates that only #1/1/2002#, #2/1/2002#,  #4/1/2002# and  #5/1/2002# dates returns 1, since the others returns 0. For instance the following sample specifies the hour being non-working for specified dates: "date(shortdate(value)) case(default:0;#4/1/2009# : hour(value) >= 6 and hour(value) <= 12 ; #4/5/2009# : hour(value) >= 7 and hour(value) <= 10 or hour(value) in(15,16,18,22); #5/1/2009# : hour(value) <= 8)" statement indicates the working hours for dates as follows:

• • #4/1/2009#, from hours 06:00 AM to 12:00 PM
  • #4/5/2009#, from hours 07:00 AM to 10:00 AM and hours 03:00PM, 04:00PM, 06:00PM and 10:00PM
  • #5/1/2009#, from hours 12:00 AM to 08:00 AM

The in, switch and case() use binary search to look for elements so they are faster then using iif and or expressions.

Obviously, the priority of the operations inside the expression is determined by ( ) parenthesis and the priority for each operator. 

The supported conversion unary operators are:

• type (unary operator) retrieves the type of the object. For instance type(%0) = 8 specifies the cells that contains string values. 

  Here's few predefined types:

  • 0 - empty ( not initialized )
  • 1 - null
  • 2 - short
  • 3 - long
  • 4 - float
  • 5 - double
  • 6 - currency
  • 7 - date
  • 8 - string
  • 9 - object
  • 10 - error
  • 11 - boolean
  • 12 - variant
  • 13 - any
  • 14 - decimal
  • 16 - char
  • 17 - byte
  • 18 - unsigned short 
  • 19 - unsigned long
  • 20 - long on 64 bits 
  • 21 - unsigned long on 64 bites
• str (unary operator) converts the expression to a string
• dbl (unary operator) converts the expression to a number
• date (unary operator) converts the expression to a date
• date (unary operator) converts the expression to a date, based on your regional settings 
• dateS (unary operator) converts the string expression to a date using the format MM/DD/YYYY HH:MM:SS

Other known operators for numbers are:

• int (unary operator) retrieves the integer part of the number
• round (unary operator) rounds the number ie 1.2 gets 1, since 1.8 gets 2
• floor (unary operator) returns the largest number with no fraction part that is not greater than the value of its argument
• abs (unary operator) retrieves the absolute part of the number ie -1 gets 1, 2 gets 2
• value format 'flags' (binary operator) formats the value with specified flags. If flags is empty, the number is displayed as shown in the field "Number" in the "Regional and Language Options" from the Control Panel. For instance the 1000 format '' displays 1,000.00 for English format, while 1.000,00 is displayed for German format. 1000 format '2|.|3|,' will always displays 1,000.00 no matter of settings in the control panel. If formatting the number fails for some invalid parameter, the value is displayed with no formatting. 

  The ' flags' for format operator is a list of values separated by | character such as 'NumDigits|DecimalSep|Grouping|ThousandSep|NegativeOrder|LeadingZero' with the following meanings: 

  • NumDigits - specifies the number of fractional digits, If the flag is missing, the field "No. of digits after decimal" from "Regional and Language Options" is using.
  • DecimalSep - specifies the decimal separator. If the flag is missing, the field "Decimal symbol" from "Regional and Language Options" is using.
  • Grouping - indicates the number of digits in each group of numbers to the left of the decimal separator. Values in the range 0 through 9 and 32 are valid. The most significant grouping digit indicates the number of digits in the least significant group immediately to the left of the decimal separator. Each subsequent grouping digit indicates the next significant group of digits to the left of the previous group. If the last value supplied is not 0, the remaining groups repeat the last group. Typical examples of settings for this member are: 0 to group digits as in 123456789.00; 3 to group digits as in 123,456,789.00; and 32 to group digits as in 12,34,56,789.00. If the flag is missing, the field "Digit grouping" from "Regional and Language Options" indicates the grouping flag.
  • ThousandSep - specifies the thousand separator. If the flag is missing, the field "Digit grouping symbol" from "Regional and Language Options" is using.
  • NegativeOrder - indicates the negative number mode. If the flag is missing, the field "Negative number format" from "Regional and Language Options" is using. The valid values are 0, 1, 2, 3 and 4 with the following meanings:
    • 0 - Left parenthesis, number, right parenthesis; for example, (1.1) 
    • 1 - Negative sign, number; for example, -1.1
    • 2 - Negative sign, space, number; for example, - 1.1
    • 3 - Number, negative sign; for example, 1.1-
    • 4 - Number, space, negative sign; for example, 1.1 -
  • LeadingZero - indicates if leading zeros should be used in decimal fields.  If the flag is missing, the field "Display leading zeros" from "Regional and Language Options" is using. The valid values are 0, 1

Other known operators for strings are:

• len (unary operator) retrieves the number of characters in the string
• lower (unary operator) returns a string expression in lowercase letters
• upper (unary operator) returns a string expression in uppercase letters
• proper (unary operator) returns from a character expression a string capitalized as appropriate for proper names
• ltrim (unary operator) removes spaces on the left side of a string
• rtrim (unary operator) removes spaces on the right side of a string
• trim (unary operator) removes spaces on both sides of a string
• startwith (binary operator) specifies whether a string starts with specified string
• endwith (binary operator) specifies whether a string ends with specified string
• contains (binary operator) specifies whether a string contains another specified string
• left (binary operator) retrieves the left part of the string
• right (binary operator) retrieves the right part of the string
• a mid b (binary operator) retrieves the middle part of the string a starting from b ( 1 means first position, and so on )
• a count b (binary operator) retrieves the number of occurrences of the b in a
• a replace b with c (double binary operator) replaces in a the b with c, and gets the result.

Other known operators for dates are:

• time (unary operator) retrieves the time of the date in string format, as specified in the control's panel.
• timeF (unary operator) retrieves the time of the date in string format, as "HH:MM:SS". For instance the timeF(1:23 PM) returns "13:23:00"
• shortdate (unary operator) formats a date as a date string using the short date format, as specified in the control's panel.
• shortdateF (unary operator) formats a date as a date string using the "MM/DD/YYYY" format. For instance the shortdateF(December 31, 1971 11:00 AM) returns "12/31/1971".
• dateF (unary operator) converts the date expression to a string expression in "MM/DD/YYYY HH:MM:SS" format.
• longdate (unary operator) formats a date as a date string using the long date format, as specified in the control's panel.
• year (unary operator) retrieves the year of the date (100,...,9999)
• month (unary operator) retrieves the month of the date ( 1, 2,...,12 )
• day (unary operator) retrieves the day of the date ( 1, 2,...,31 )
• yearday (unary operator) retrieves the number of the day in the year, or the days since January 1st ( 0, 1,...,365 )
• weekday (unary operator) retrieves the number of days since Sunday ( 0 - Sunday, 1 - Monday,..., 6 - Saturday )
• hour (unary operator) retrieves the hour of the date ( 0, 1, ..., 23 )
• min (unary operator) retrieves the minute of the date ( 0, 1, ..., 59 )
• sec (unary operator) retrieves the second of the date ( 0, 1, ..., 59 )

The expression supports also immediate if ( similar with iif in visual basic, or ? : in C++ ) ie cond ? value_true : value_false, which means that once that cond is true the value_true is used, else the value_false is used. Also, it supports variables, up to 10 from 0 to 9. For instance, 0:="Abc" means that in the variable 0 is "Abc", and =:0 means retrieves the value of the variable 0. You can use variables to avoid computing several times the same thing.

The following VB sample shows how you can highlight the last Friday for each month::

With G2antt1
	With .Chart
		.PaneWidth(0) = 0
		.FirstVisibleDate = #1/17/2008#
		.LevelCount = 2
		.Level(1).FormatLabel = "(weekday(dvalue)=5 ? month(dvalue+7)!=month(dvalue) ? '<b><bgcolor=000000><fgcolor=FFFFFF>' ) +" & _
" value"
	End With
End With

With G2antt1
	.BeginUpdate 
	With .Chart
		.ToolTip = ""
		.PaneWidth(0) = 0
		.ScrollRange(exStartDate) = 0
		.ScrollRange(exEndDate) = 110
		.FirstVisibleDate = 0
		.ShowNonworkingDates = False
		.MarkTodayColor = .BackColor
		.LevelCount = 3
		With .Level(0)
			.ToolTip = ""
			.Alignment = CenterAlignment
			.Unit = exDay
			.Count = 16
			.FormatLabel = "'Group <b>'+int(1 +dvalue/16)"
		End With
		With .Level(1)
			.ToolTip = ""
			.Alignment = CenterAlignment
			.Unit = exDay
			.Count = 4
			.FormatLabel = " (abs(dvalue)/4) mod 4"
			.ReplaceLabel("0") = "Sub-Group <b>1</b>"
			.ReplaceLabel("1") = "Sub-Group <b>2</b>"
			.ReplaceLabel("2") = "Sub-Group <b>3</b>"
			.ReplaceLabel("3") = "Sub-Group <b>4</b>"
		End With
		With .Level(2)
			.ToolTip = ""
			.Unit = exDay
			.Count = 1
			.FormatLabel = "(abs(dvalue) mod 4)"
			.ReplaceLabel("0") = "A"
			.ReplaceLabel("1") = "B"
			.ReplaceLabel("2") = "C"
			.ReplaceLabel("3") = "D"
		End With
	End With
	.EndUpdate 
End With

The following VB.NET sample shows how you can highlight the last Friday for each month::

With AxG2antt1
	With .Chart
		.PaneWidth(0) = 0
		.FirstVisibleDate = #1/17/2008#
		.LevelCount = 2
		.Level(1).FormatLabel = "(weekday(dvalue)=5 ? month(dvalue+7)!=month(dvalue) ? '<b><bgcolor=000000><fgcolor=FFFFFF>' ) +" & _
" value"
	End With
End With

With AxG2antt1
	.BeginUpdate 
	With .Chart
		.ToolTip = ""
		.PaneWidth(0) = 0
		.ScrollRange(EXG2ANTTLib.ScrollRangeEnum.exStartDate) = 0
		.ScrollRange(EXG2ANTTLib.ScrollRangeEnum.exEndDate) = 110
		.FirstVisibleDate = 0
		.ShowNonworkingDates = False
		.MarkTodayColor = .BackColor
		.LevelCount = 3
		With .Level(0)
			.ToolTip = ""
			.Alignment = EXG2ANTTLib.AlignmentEnum.CenterAlignment
			.Unit = EXG2ANTTLib.UnitEnum.exDay
			.Count = 16
			.FormatLabel = "'Group <b>'+int(1 +dvalue/16)"
		End With
		With .Level(1)
			.ToolTip = ""
			.Alignment = EXG2ANTTLib.AlignmentEnum.CenterAlignment
			.Unit = EXG2ANTTLib.UnitEnum.exDay
			.Count = 4
			.FormatLabel = " (abs(dvalue)/4) mod 4"
			.ReplaceLabel("0") = "Sub-Group <b>1</b>"
			.ReplaceLabel("1") = "Sub-Group <b>2</b>"
			.ReplaceLabel("2") = "Sub-Group <b>3</b>"
			.ReplaceLabel("3") = "Sub-Group <b>4</b>"
		End With
		With .Level(2)
			.ToolTip = ""
			.Unit = EXG2ANTTLib.UnitEnum.exDay
			.Count = 1
			.FormatLabel = "(abs(dvalue) mod 4)"
			.ReplaceLabel("0") = "A"
			.ReplaceLabel("1") = "B"
			.ReplaceLabel("2") = "C"
			.ReplaceLabel("3") = "D"
		End With
	End With
	.EndUpdate 
End With

The following C++ sample shows how you can highlight the last Friday for each month::

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXG2ANTTLib' for the library: 'ExG2antt 1.0 Control Library'

	#import <ExG2antt.dll>
	using namespace EXG2ANTTLib;
*/
EXG2ANTTLib::IG2anttPtr spG2antt1 = GetDlgItem(IDC_G2ANTT1)->GetControlUnknown();
EXG2ANTTLib::IChartPtr var_Chart = spG2antt1->GetChart();
	var_Chart->PutPaneWidth(0,0);
	var_Chart->PutFirstVisibleDate("1/17/2008");
	var_Chart->PutLevelCount(2);
	var_Chart->GetLevel(1)->PutFormatLabel(_bstr_t("(weekday(dvalue)=5 ? month(dvalue+7)!=month(dvalue) ? '<b><bgcolor=000000><fgcolor=FFFFFF>' ) +") +
" value");

/*
	Copy and paste the following directives to your header file as
	it defines the namespace 'EXG2ANTTLib' for the library: 'ExG2antt 1.0 Control Library'

	#import <ExG2antt.dll>
	using namespace EXG2ANTTLib;
*/
EXG2ANTTLib::IG2anttPtr spG2antt1 = GetDlgItem(IDC_G2ANTT1)->GetControlUnknown();
spG2antt1->BeginUpdate();
EXG2ANTTLib::IChartPtr var_Chart = spG2antt1->GetChart();
	var_Chart->PutToolTip(L"");
	var_Chart->PutPaneWidth(0,0);
	var_Chart->PutScrollRange(EXG2ANTTLib::exStartDate,long(0));
	var_Chart->PutScrollRange(EXG2ANTTLib::exEndDate,long(110));
	var_Chart->PutFirstVisibleDate(long(0));
	var_Chart->PutShowNonworkingDates(VARIANT_FALSE);
	var_Chart->PutMarkTodayColor(var_Chart->GetBackColor());
	var_Chart->PutLevelCount(3);
	EXG2ANTTLib::ILevelPtr var_Level = var_Chart->GetLevel(0);
		var_Level->PutToolTip("");
		var_Level->PutAlignment(EXG2ANTTLib::CenterAlignment);
		var_Level->PutUnit(EXG2ANTTLib::exDay);
		var_Level->PutCount(16);
		var_Level->PutFormatLabel(L"'Group <b>'+int(1 +dvalue/16)");
	EXG2ANTTLib::ILevelPtr var_Level1 = var_Chart->GetLevel(1);
		var_Level1->PutToolTip("");
		var_Level1->PutAlignment(EXG2ANTTLib::CenterAlignment);
		var_Level1->PutUnit(EXG2ANTTLib::exDay);
		var_Level1->PutCount(4);
		var_Level1->PutFormatLabel(L" (abs(dvalue)/4) mod 4");
		var_Level1->PutReplaceLabel(L"0",L"Sub-Group <b>1</b>");
		var_Level1->PutReplaceLabel(L"1",L"Sub-Group <b>2</b>");
		var_Level1->PutReplaceLabel(L"2",L"Sub-Group <b>3</b>");
		var_Level1->PutReplaceLabel(L"3",L"Sub-Group <b>4</b>");
	EXG2ANTTLib::ILevelPtr var_Level2 = var_Chart->GetLevel(2);
		var_Level2->PutToolTip("");
		var_Level2->PutUnit(EXG2ANTTLib::exDay);
		var_Level2->PutCount(1);
		var_Level2->PutFormatLabel(L"(abs(dvalue) mod 4)");
		var_Level2->PutReplaceLabel(L"0",L"A");
		var_Level2->PutReplaceLabel(L"1",L"B");
		var_Level2->PutReplaceLabel(L"2",L"C");
		var_Level2->PutReplaceLabel(L"3",L"D");
spG2antt1->EndUpdate();

The following C# sample shows how you can highlight the last Friday for each month::

EXG2ANTTLib.Chart var_Chart = axG2antt1.Chart;
	var_Chart.set_PaneWidth(0 != 0,0);
	var_Chart.FirstVisibleDate = "1/17/2008";
	var_Chart.LevelCount = 2;
	var_Chart.get_Level(1).FormatLabel = "(weekday(dvalue)=5 ? month(dvalue+7)!=month(dvalue) ? '<b><bgcolor=000000><fgcolor=FFFFFF>' ) +" +
" value";

axG2antt1.BeginUpdate();
EXG2ANTTLib.Chart var_Chart = axG2antt1.Chart;
	var_Chart.ToolTip = "";
	var_Chart.set_PaneWidth(0 != 0,0);
	var_Chart.set_ScrollRange(EXG2ANTTLib.ScrollRangeEnum.exStartDate,0);
	var_Chart.set_ScrollRange(EXG2ANTTLib.ScrollRangeEnum.exEndDate,110);
	var_Chart.FirstVisibleDate = 0;
	var_Chart.ShowNonworkingDates = false;
	var_Chart.MarkTodayColor = var_Chart.BackColor;
	var_Chart.LevelCount = 3;
	EXG2ANTTLib.Level var_Level = var_Chart.get_Level(0);
		var_Level.ToolTip = "";
		var_Level.Alignment = EXG2ANTTLib.AlignmentEnum.CenterAlignment;
		var_Level.Unit = EXG2ANTTLib.UnitEnum.exDay;
		var_Level.Count = 16;
		var_Level.FormatLabel = "'Group <b>'+int(1 +dvalue/16)";
	EXG2ANTTLib.Level var_Level1 = var_Chart.get_Level(1);
		var_Level1.ToolTip = "";
		var_Level1.Alignment = EXG2ANTTLib.AlignmentEnum.CenterAlignment;
		var_Level1.Unit = EXG2ANTTLib.UnitEnum.exDay;
		var_Level1.Count = 4;
		var_Level1.FormatLabel = " (abs(dvalue)/4) mod 4";
		var_Level1.set_ReplaceLabel("0","Sub-Group <b>1</b>");
		var_Level1.set_ReplaceLabel("1","Sub-Group <b>2</b>");
		var_Level1.set_ReplaceLabel("2","Sub-Group <b>3</b>");
		var_Level1.set_ReplaceLabel("3","Sub-Group <b>4</b>");
	EXG2ANTTLib.Level var_Level2 = var_Chart.get_Level(2);
		var_Level2.ToolTip = "";
		var_Level2.Unit = EXG2ANTTLib.UnitEnum.exDay;
		var_Level2.Count = 1;
		var_Level2.FormatLabel = "(abs(dvalue) mod 4)";
		var_Level2.set_ReplaceLabel("0","A");
		var_Level2.set_ReplaceLabel("1","B");
		var_Level2.set_ReplaceLabel("2","C");
		var_Level2.set_ReplaceLabel("3","D");
axG2antt1.EndUpdate();

The following VFP sample shows how you can highlight the last Friday for each month::

with thisform.G2antt1
	with .Chart
		.PaneWidth(0) = 0
		.FirstVisibleDate = {^2008-1-17}
		.LevelCount = 2
		var_s = "(weekday(dvalue)=5 ? month(dvalue+7)!=month(dvalue) ? '<b><bgcolor=000000><fgcolor=FFFFFF>' ) + "
		var_s = var_s + "value"
		.Level(1).FormatLabel = var_s
	endwith
endwith

with thisform.G2antt1
	.BeginUpdate
	with .Chart
		.ToolTip = ""
		.PaneWidth(0) = 0
		.ScrollRange(0) = 0
		.ScrollRange(1) = 110
		.FirstVisibleDate = 0
		.ShowNonworkingDates = .F.
		.MarkTodayColor = .BackColor
		.LevelCount = 3
		with .Level(0)
			.ToolTip = ""
			.Alignment = 1
			.Unit = 4096
			.Count = 16
			.FormatLabel = "'Group <b>'+int(1 +dvalue/16)"
		endwith
		with .Level(1)
			.ToolTip = ""
			.Alignment = 1
			.Unit = 4096
			.Count = 4
			.FormatLabel = " (abs(dvalue)/4) mod 4"
			.ReplaceLabel("0") = "Sub-Group <b>1</b>"
			.ReplaceLabel("1") = "Sub-Group <b>2</b>"
			.ReplaceLabel("2") = "Sub-Group <b>3</b>"
			.ReplaceLabel("3") = "Sub-Group <b>4</b>"
		endwith
		with .Level(2)
			.ToolTip = ""
			.Unit = 4096
			.Count = 1
			.FormatLabel = "(abs(dvalue) mod 4)"
			.ReplaceLabel("0") = "A"
			.ReplaceLabel("1") = "B"
			.ReplaceLabel("2") = "C"
			.ReplaceLabel("3") = "D"
		endwith
	endwith
	.EndUpdate
endwith