[fdo-internals] CurrentDate and ExtractToInt for King.Oracle
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?
More information about the fdo-internals