locked
How to update a date custom field to "NA" or null in PSI? RRS feed

  • Question

  • I apologize if I am missing something trivial but I need a way to set a date value back to "NA" or blank and I am not seeing a way through the PSI.

    I've tried setting it to DateTime.Min but it won't accept that.

    Tuesday, April 8, 2014 9:03 PM

All replies

  • Update.

    I thought I needed to delete the project custom field but when I set it for deletion using Delete() it doesn't actually delete the custom field.

    I tried forcing the deletion but get the following error in the queue:

    • ProjectCannotDeleteItem (1161). Details: id='1161'
      name='ProjectCannotDeleteItem' uid='db026a18-a5f5-4a55-a5b9-a910ea1af963'
      itemID='2de77008-ef21-4fe8-8fd5-b90bb8a2888c'.

    It made sense to me because looking at the MSP_PROJ_CUSTOM_FIELD_VALUES table it only shows custom fields that have been set.

    I must be going in the wrong direction with an error like that though.

    Tuesday, April 8, 2014 11:55 PM
  • To assign a value to custom field you need to create a CustomFieldRow. If you do not create one, the value will be blank.

    Wednesday, April 9, 2014 6:30 AM