How Can I Create a Calculated Date Field in SalesLogix?

Question:

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?

Answer:

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

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!