I created a calculated date field using SQL DATEADD function and it returns the correct data successfully. What I’d like to do now is use this calculated field in a condition for defining a group — for example <CalculatedField> within next 90 days.
Unfortunately when I add the field to the Conditions tab, it shows up as a Decimal field and won’t even accept a static date. Any advice?
a) Use an SQL View on which you include a field with the Calculation, then Enable the View within DB Manager, On your Group, Join the View and work with your Date Field. (Should work with Remotes).
b) Use an SQL Calculated Field instead of a SalesLogix Calculated Field. (Not sure if this will work with remotes).