How to set expiration date via csv update?

Forum|Forum|4 years ago
October 8, 2021
1 reply
1936 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by manpreetk908

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

manpreetk908Accepted solution

New Participant

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

J

jdvhfluteAuthor

New Participant

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

New Participant

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

Regards,

Manpreet

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded