Manuals/calci/FROMTOADV

Revision as of 05:45, 18 February 2020 by Devika (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

  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

References

Date