FnSnap: Date and Time

From Br Wiki
Jump to: navigation, search


Date formatting

FNCCYYMMDD_TO_DAYS - converts CYMD to DAYS

Converts CYMD to DAYS

FNCCYYMMDD_TO_DAYS(&DAT)

Functions used |

Variables
DAT date to be converted in DAYS format


Comments



FNDATEFWD

FNDATEFWD(DATEIN;CENTURY)- Converts YYMMDD to MMDDYY

Description|
Converts YYMMDD to MMDDYY with option of including century

Functions used |None

Variables
DATEIN date in YYMMDD format


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
DATEIN date in MMDDYY format
CENTURY 1 if century is to be included CCYY0 if no century, only year YY


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
DAYSIN date to be converted in DAYS format


Comments



FNDAYS_TO_MMDDCCYY - Converts DAYS to MDCY

Converts DAYS to MDCY

FNDAYS_TO_MMDDCCYY(&DAT)

Functions used |

Variables
DAT date to be converted in DAYS format


Comments



FNDAYS_TO_MMDDYY - Converts DAYS to MMDDYY

Converts DAYS to MDY

FNDAYS_TO_MMDDYY(&DAT)

Functions used |

Variables
DAT date to be converted in DAYS format


Comments



FNMDY2YMD - converts YYMMDD to MMDDYY with century option

Converts YYMMDD to MMDDYY with option of including century

FNMDY2YMD(DATEIN;CENTURY)

Functions used |

Variables
DAYSIN date to be converted in DAYS format
CENTURY 1 if century is to be included0 if no century


Comments



FNMMDDCCYY_TO_DAYS - converts MDCY to DAYS

Converts MDCY to DAYS

FNMMDDCCYY_TO_DAYS(&DAT)

Functions used |

Variables
DAT date to be converted in DAYS format


Comments



FNMMDDYY_TO_DAYS - Converts MDY to DAYS

Converts MDY to days

FNMMDDYY_TO_DAYS(&DAT)

Functions used |

Variables
DAT date to be converted in DAYS format


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
MILTIM time in military 24 hour format
HOUR the hour in 12 hour time to be returned
MINUTES minutes to be returned
AMPM$ designation of AM or PM to be returned


Comments



FNYMD2MDY - converts MMDDYY to YYMMDD with century option

Converts MMDDYY to YYMMDD with option of including century

FNYMD2MDY(DATEIN;CENTURY)

Functions used |

Variables
DAYSIN date to be converted in DAYS format
CENTURY 1 if century is to be included, 0 if no century


Comments



FNYYMMDD_TO_DAYS - convert YMD to DAYS

Converts YMD to DAYS

FNYYMMDD_TO_DAYS(&DAT)

Functions used |

Variables
DAT date to be converted in DAYS format


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
XDATE Date in days that is the starting point for calculations


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
D Date in days to be calculated


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
INDATE date to be converted in DAYS format


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
XDATE Seed date in days


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
WEEKDAY date to be converted in DAYS format


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
D Date for which the calculation is being done


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
D Date to be processed in days


Comments