FnSnap: Date and Time

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