Skip to main content
arshbirs0002
New Participant
Oct 19, 2021 2:10 PM UTC
Question

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

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
    peter.lewis
    Employee
    Oct 19, 2021 4:36 PM UTC

    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.

    farnazy997
    Participating Frequently
    Oct 21, 2021 11:14 AM UTC

    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

    Terms & ConditionsAccessibility statement