LastDay Function

Number of input and output field

Number of input field : One
Number of output field : One

This transformation function is used to determine the last day of a given timestamp or a specified year and month.

The result is a numeric value representing the number of days in the corresponding month for the given year.

Possible parameter values:
Parameter ValueDescription
no parameter (BLANK)The input is read as a timestamp.
YYYYMM
YYYY MM
YYYY-MM
YYYY/MM
MMYYYY
MM YYYY
MM-YYYY
MM/YYYY
otherThe format is as described in CurrentTimestampString