Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How to set expiration date via csv update?

jdvhflute
Level 1
Level 1

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

1 Accepted Solution
manpreetk908
Correct answer by
Level 4
Level 4

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

View solution in original post

3 Replies
manpreetk908
Correct answer by
Level 4
Level 4

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

View solution in original post

jdvhflute
Level 1
Level 1

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
Level 4
Level 4

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

 

Regards,

Manpreet