CA Service Management

  • 1.  Xtraction Change Order Dashboard custom date issue

    Posted Aug 02, 2018 06:23 AM

    Hi Team

     

    We are running xtraction 17 and we have few custom fields for change order dashboard. See below snapshots. We custom UAT Date , Golive Date & Vendor Date. Problem is that when these fields leave blank , In dashboard, it fetch 1970's date which is not acceptable.it should be blank .

    When we select particular date on these 3 custom date fields. then the result is ok. But leaving it blank is making issue for us.

     

    below snapshots for your information. Please advise.

     

     

     



  • 2.  Re: Xtraction Change Order Dashboard custom date issue
    Best Answer

    Posted Aug 02, 2018 09:36 AM

    Hi,

     

    Date fields in Xtraction can't have case statements as their expression. Try changing the expression to CHANGE.ZUATDATE. You can also look at the out of the box date examples from the data model to see how to add date fields.