Formula to retrieve Application Property such as Global Time

kmdyda
New Contributor II

Is there a formula (for use in Excel/Spreadsheet) to retrieve the Global Time setting from Application Properties?

2 REPLIES 2

kmdyda
New Contributor II

I think I found answer?  Just put "Global" as the Time member in the XFGetCell formula?

db_pdx
Contributor III

Correct.  Generally speaking, all the available Time Functions from the Member Filter Builder are available for use in an XFGetCell; but some are more useful than others when passing in parameters through Excel.