Laura: 1 revision

2013-07-11T17:09:05Z

1 revision

New page

==Date formatting==
===FNCCYYMMDD_TO_DAYS - converts CYMD to DAYS===

Converts CYMD to DAYS

FNCCYYMMDD_TO_DAYS(&DAT)

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''DAT date to be converted in DAYS format
|-valign="top"
|}
 
;Comments:

===FNDATEFWD===

FNDATEFWD(DATEIN;CENTURY)- Converts YYMMDD to MMDDYY

Description| 
Converts YYMMDD to MMDDYY with option of including century

Functions used |None

;Variables:
{|
|-valign="top"
|width="10%"|'''DATEIN'''||date in YYMMDD format
|-valign="top"
|}
 
;Comments:

If century is true then the date is output in MDCY format

===FNDATEREV - converts MMDDYY to YYMMDD===

FNDATEREV(DATEIN;CENTURY) ! Convert MMDDYY to YYMMDD with optional addition of century MMDDCCYY to YYMMDD if century >0

Description| 
Converts MMDDYY to YYMMDD with option of including century

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''DATEIN'''||date in MMDDYY format
|-valign="top"
|width="10%"|'''CENTURY'''||1 if century is to be included CCYY0 if no century, only year YY
|-valign="top"
|}
 
;Comments:

===FNDATE$ - Creates a formatted date from DAYS input===

Creates a formatted date from a DAYS input. Example January 5,2003 Beginning with 4.17 this can be done directly by BR.

FNDATE$(DAYSIN)

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''DAYSIN'''||date to be converted in DAYS format
|-valign="top"
|}
 
;Comments:

===FNDAYS_TO_MMDDCCYY - Converts DAYS to MDCY===

Converts DAYS to MDCY

FNDAYS_TO_MMDDCCYY(&DAT)

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''DAT'''||date to be converted in DAYS format
|-valign="top"
|}
 
;Comments:

===FNDAYS_TO_MMDDYY - Converts DAYS to MMDDYY===

Converts DAYS to MDY

FNDAYS_TO_MMDDYY(&DAT)

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''DAT'''||date to be converted in DAYS format
|-valign="top"
|}
 
;Comments:

===FNMDY2YMD - converts YYMMDD to MMDDYY with century option===

Converts YYMMDD to MMDDYY with option of including century

FNMDY2YMD(DATEIN;CENTURY)

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''DAYSIN'''|| date to be converted in DAYS format
|-valign="top"
|width="10%"|'''CENTURY'''||1 if century is to be included0 if no century
|-valign="top"
|}
 
;Comments:

===FNMMDDCCYY_TO_DAYS - converts MDCY to DAYS===

Converts MDCY to DAYS

FNMMDDCCYY_TO_DAYS(&DAT)

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''DAT date to be converted in DAYS format
|-valign="top"
|}
 
;Comments:

===FNMMDDYY_TO_DAYS - Converts MDY to DAYS===

Converts MDY to days

FNMMDDYY_TO_DAYS(&DAT)

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''DAT'''||date to be converted in DAYS format
|-valign="top"
|}
 
;Comments:

===FNTIMMILREG - 12 hour time from 24 hour time===

Returns regular 12 hour time from 24 hour military time

FNTIMMILREG(MILTIM,&HOUR,&MINUTES,&AMPM$) !:

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''MILTIM'''||time in military 24 hour format
|-valign="top"
|width="10%"|'''HOUR'''||the hour in 12 hour time to be returned
|-valign="top"
|width="10%"|'''MINUTES'''||minutes to be returned
|-valign="top"
|width="10%"|'''AMPM$'''||designation of AM or PM to be returned
|-valign="top"
|}
 
;Comments:

===FNYMD2MDY - converts MMDDYY to YYMMDD with century option===

Converts MMDDYY to YYMMDD with option of including century

FNYMD2MDY(DATEIN;CENTURY)

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''DAYSIN'''|| date to be converted in DAYS format
|-valign="top"
|width="10%"|'''CENTURY'''|| 1 if century is to be included, 0 if no century
|-valign="top"
|}
 
;Comments:

===FNYYMMDD_TO_DAYS - convert YMD to DAYS===

Converts YMD to DAYS

FNYYMMDD_TO_DAYS(&DAT)

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''DAT date to be converted in DAYS format
|-valign="top"
|}
 
;Comments:

==Relative and special dates==
===FNBUSINESSDAY - returns the next business day after or including a specified date===

increases the given date until it is not a weekend or legal holiday

FNBUSINESSDAY(XDATE)

;Functions used:

;Variables:
{|
|-valign="top"
|width="10%"|'''XDATE '''||Date in days that is the starting point for calculations
|-valign="top"
|}
 
;Comments: 
Useful in determining settlement dates for federal and state tax payments. 
The holidays calculated are federal legal banking holidays only, no state or local holidays are included.

===FNDAYOFYEAR - ordinal number of days from beginning of calendar year===

Calculates what day any days date is within the calendar year that it is located

FNDAYOFYEAR(D)

;Functions used:

;Variables:
{|
|-valign="top"
|width="10%"|'''D '''||Date in days to be calculated
|-valign="top"
|}
 
;Comments:

===FNNEXTMONTH - similar date in the following month===

Returns a similar date for the following month based on number of days before month end

FNNEXTMONTH(INDATE)

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''INDATE '''||date to be converted in DAYS format
|-valign="top"
|}
 
;Comments: 
If the date given is the 29th day of a 31 day month and the following month contains 30 days the returned value will be the 28th day of the following month.

===FNPRIOR BUSINESSDAY - returns the first business day prior to a given date including the given date===

Decreases the given date until it is not a weekend or legal holiday

FNPRIOBUSINESSDAY(XDATE)

;Functions used:

;Variables:
{|
|-valign="top"
|width="10%"|'''XDATE '''||Seed date in days
|-valign="top"
|}
 
;Comments: 
Will calculate the available date for a banking transaction prior to or including the seed date. Useful in determining the settlement date for payroll direct deposit dating and payroll account funding in advance of a payroll.

===FNWEEKDAY$ - Returns the day of the week===

Returns the day of the week from a DAYS input

FNWEEKDAY$(WEEKDAY) !:

Functions used |

;Variables:
{|
|-valign="top"
|width="10%"|'''WEEKDAY'''||date to be converted in DAYS format
|-valign="top"
|}
 
;Comments:

===FNWEEKOFMONTH - number of time a specified day of week has occur ed in the month specified===

Returns the week number within a month of a specified date assuming that the first time that that day of the week occurred in the month was the first week of the month.

FNWEEKOFMONTH(D)

;Functions used:

;Variables:
{|
|-valign="top"
|width="10%"|'''D'''||Date for which the calculation is being done
|-valign="top"
|}
 
;Comments: 
Useful in determining what deduction in a payroll system should be activated if the deductions only occur on certain weeks of the month.

===FNWEEKOFYEAR - number of times a specified day of week has occurred in a year up to a specified date===

Returns the number of the week of the year for a specified date, assuming that the specified day of the week first occurred in the first week of the year.

FNWEEKOFYEAR(D)

;Functions used:

;Variables:
{|
|-valign="top"
|width="10%"|'''D '''||Date to be processed in days
|-valign="top"
|}
 
;Comments:

[[Category:FnSnap]]

FnSnap: Date and Time - Revision history

Laura: 1 revision