[fdo-internals] CurrentDate and ExtractToInt for King.Oracle

Trevor Wekel trevor_wekel at otxsystems.com
Wed Nov 24 16:34:24 EST 2010

Hello Fdo wizards,

I am seeing an interesting quirk with the King.Oracle provider.  If ExtractToInt('YEAR', CurrentDate()) is used in a tooltip, I get "2010" back.  If the same statement is used in a filter, ExtractToInt('YEAR', CurrentDate()) = '2010' then it does not work.  The GetCapabilities document for King.Oracle does not include the ExtractToInt() or CurrentDate() functions.  However, I thought these function were implemented by the expression engine and were common to all providers.

Can anyone provide some enlightenment on this behaviour?

Thank you,

More information about the fdo-internals mailing list