You are viewing limited content. For full access, please sign in.

Question

Question

Generate report by Export metadata [error] date format to excel

asked on August 1, 2018

Dear all,

Our user found the dates are not recognized automatically with the standard date format (for Excel use) when they export to excel file.

 

How can we maintain data format as require from Laserfiche?  We did try to setting date but Laserfiche don't have much choice to choose.

 

Regards,

0 0

Replies

replied on August 1, 2018

Hi Somjeat,

I am not sure what your export process to Excel is, but you could use Workflow to "translate" the date format from standard to whichever format you need, then write to Excel.

The other thing to look at is your metadata fields - are the dates being stored in a field that is set to date type or is the field set to characters? You can check this in your Laserfiche Administration Console > Metadata Management > Fields, locate the one you are storing date into then make sure that the Type is "Date" and not "Text". If you need to change it to date type, be very careful how you do it because it might remove the data from that field..

1 0
replied on August 2, 2018

Thanks for your suggestion Lidija.

 

FYI that LF had filed hotfix on this last night. Defect - Bug# 103386; Workaround is to generate the report as a Table, List or Text.

 

Regards,

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.