# Difference between revisions of "Manuals/calci/FROMTOADV"

Jump to navigation
Jump to search

(Created page with "<div style="font-size:30px">'''FROMTOADV (From,To,By) '''</div><br/> *<math>From</math> and <math>To</math> are any date. *<math>By</math> is the skip value. ==Description==...") |
|||

Line 7: | Line 7: | ||

*In <math>FROMTOADV (From,To,By)</math>,<math>From</math> is the starting date. | *In <math>FROMTOADV (From,To,By)</math>,<math>From</math> is the starting date. | ||

*<math>To</math> is the end date and <math>By</math> is the skip value. | *<math>To</math> is the end date and <math>By</math> is the skip value. | ||

− | *Here this function displays all | + | *When we are omitting the <math>By</math> 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 <math>From</math> is not a valid date, or if it is not in the DATE function format. | ||

+ | 2.<math>By</math> is not an Integer. | ||

+ | |||

==Examples== | ==Examples== |

## Latest revision as of 05:45, 18 February 2020

**FROMTOADV (From,To,By)**

- and are any date.
- is the skip value.

## Description

- This function displays the date within the given range of dates.
- In , is the starting date.
- is the end date and is the skip value.
- When we are omitting the 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 is not a valid date, or if it is not in the DATE function format. 2. is not an Integer.

## Examples

- 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
- 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
- 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