Manuals/calci/FROMTOADV

FROMTOADV (From,To,By)

• $From$ and $To$ are any date.
• $By$ is the skip value.

Description

• This function displays the date within the given range of dates.
• In $FROMTOADV(From,To,By)$,$From$ is the starting date.
• $To$ is the end date and $By$ is the skip value.
• When we are omitting the $By$ value,then it will assigned as 1.
• Here this function displays all dates within the given range.
• We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
• This function will show the result as error when

1.The $From$ is not a valid date, or if it is not in the DATE function format.
2.$By$ is not an Integer.

Examples

1. FROMTOADV("3/2/2001","3/12/2001",2) = 03/02/2001 03/04/2001 03/06/2001 03/08/2001 03/10/2001 03/12/2001
2. FROMTOADV("12/9/2005","9/17/2006",22) = 12/09/2005 12/31/2005 01/22/2006 02/13/2006 03/07/2006 03/29/2006 04/20/2006 05/12/2006 06/03/2006 06/25/2006 07/17/2006 08/08/2006 08/30/2006 09/21/2006
3. FROMTOADV("2/20/2000","3/10/2000") = 02/20/2000 02/21/2000 02/22/2000 02/23/2000 02/24/2000 02/25/2000 02/26/2000 02/27/2000 02/28/2000 02/29/2000 03/01/2000 03/02/2000 03/03/2000 03/04/2000 03/05/2000 03/06/2000 03/07/2000 03/08/2000 03/09/2000 03/10/2000

Related Videos

From Values

See Also

• FROMTO
• MOMENT
• DAYS

References

Date

• List of Main Z Functions
• Z3 home