PUNCH

Returns a punch attribute from the current day by specifying which punch ("First", "Last", "Any") and the attribute to return

Example Usage

PUNCH("2022-03-22", "First", "Excused") -> 1 if "Excused" exists in the first punch record of the day and is selected

Overview

Function signature
PUNCH(paydate, whichone, column)

Category
Database

Return data type
None

Arguments

Name	DataType	List Options	Description
paydate	date		The pay date to search for punches
whichone	list	First Last Any	Determines which punch to return from the current days data
column	string		The column to return from the selected punch. If "Any" was chosen for "whichone", then any punch with a non-Null value for column will be used as the return source