Navigation:  Macros > Macro Language > Built-in Functions > All Functions (Alphabetical) >


Previous pageReturn to chapter overviewNext page

int = GetHolDateFromTable()


This macro function returns the date of the current holiday in the holidays table. This function overlaps with GetDateForHolidayId and is part of a set of advanced functions that give you direct access to the holidays tables.


// if there is another holiday, display its date

if NotEqualN(GetDateForHolidayId(nHolidayId,nYear),0)

 nDate = GetHolDateFromTable()

 sRESULT = Concat('The date is ', FormatDate('c',nDate))



To set the current record to a desired holiday occurrence you would use one of the functions such as : FindNextHolidayOnDate or GetDateForHolidayIdOfYear. The 3 functions GetHolDateFromTable, GetHolIdFromTable, and GetHolNameFromTable are used to read information about the current holiday record in the holidays table.

Topic 105135 updated on 29-Sep-2017.
Topic URL: