Skip to main content
October 19, 2021
Question

I am not able to change a datetime from product record, it shows error

  • October 19, 2021
  • 2 replies
  • 0 views

Hi Team, 

I am not able to change a record of datetime to year in Appian. 

This is what I am trying

This is error I am getting :

Can someone help, I want to change that date into year for Product records on the screen

    2 replies

    peter.lewis
    Participating Frequently
    October 19, 2021

    Does it work before you add in the year function? Also what data is displayed in that grid column before adding year()? If you post the full expression of your grid that can help us troubleshoot as well.

    October 21, 2021

    Display the date time. If that's displaying as expected, then add null check to the expression. Use year() function when not null. If displaying the date time also is throwing error, check the Source of the Record, field type, primary key etc