topic d:date custom field is not searchable correctly in Alfresco Forum

d:date custom field is not searchable correctly

redflow — Tue, 05 Dec 2017 11:21:46 GMT

I'm using a custom field date. When I upload the document and metadata using CMIS I put the date in UTC putting HH:MMS as 00:00:00. When I try to find the document I couldn't find it because it was stored as Local Time (as 01:00:00).What's wrong?

Re: d:date custom field is not searchable correctly

andy1 — Thu, 07 Dec 2017 10:32:08 GMT

Can you please add all the detail for locales used (repo, client etc) , exact data values entered, value from the node browser and the query used etc....

Andy

Re: d:date custom field is not searchable correctly

redflow — Tue, 02 Jan 2018 14:56:34 GMT

Hi Andi

it was an error: during upload I don't fix correctly the date in UTC (as I was looking for).

Correcting the upload procedure to set the right field I'm able to find the record correctly.

Thank you!