GetHolDateFromTable

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

GetHolDateFromTable

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))

endif

 

To set the current record to a desired holiday occurrence you would use one of the functions such as : FindHolidayOnDate 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 01-Nov-2016.
Topic URL: http://www.qppstudio.net/webhelp/index.html?getholdatefromtable.htm