IsValidPeriodDateWithBatchName
Summary
The IsValidPeriodDateWithBatchName function checks whether the batch name input parameter falls between the start and end dates for the monthly period derived from the date input parameter. The function queries data found in the xactly.xc_user_batch table.
Syntax
IsValidPeriodDateWithBatchName(<date>|<date_time>|<instant>|<offset_date_time>|<zoned_date_time>, <string>) |
Return Type
Boolean
Details
The function returns true or false based on the whether date input parameter is associated with the batch name.
Examples
eval IsValidPeriodDateWithBatchName(‘2016-01-01’, ‘January Adjustments 2016’);
select incentive_date, batch_name,
IsValidPeriodDateWithBatchName(incentive_date, batch_name),
count(*)
from staging.order_item;
Related Functions
LookupPeriodIdByBatchName