How to set expiration date via csv update?

[jdvhflute]

I have hundreds to assets in a folder I need to set the Expiration date to expire. 

To do this, I need to set the field prism:expirationDate{{Date}} in a csv import process. This would entail setting all 100ish fields of 

prism:expirationDate{{Date}} with the same value. 

I've set the date to 2021-10-07T17:13:00-07:00 and for some reason the csv doesn't change. I know you need to set the value to a date in the present/future.

Am I doing something wrong with the date? Does the "T" value here cause a csv import to have problems? Has anyone else ever done this?

Cheers, 

JD

[manpreetk908 · Accepted solution]

Hi @jdvhflute ,

I was able to bulk update the prism:expirationDate{{Date}} for assets using date in the format "2021-08-30T01:00:00.000-00:00". Hope it helps!

Regards,

Manpreet

[jdvhflute]

This is brilliant, THANK YOU!

Would you also know how to mass remove the expiration date / set to Null? I've tried to set the field to " ' " and the field doesn't change.

Cheers, 

JD

[manpreetk908]

Did you also try by keeping the column value empty for the date in bulk import?

Regards,

Manpreet