Page 1 of 1

Output Document Date Format from Grid

Posted: Mon Jan 28, 2019 10:46 am
by danielwalters
Dear Processmaker community,

I have an output document that displays a grid of various activities. The grid contains date fields.

The date fields are set to the format DD-MM-YYYY when used in dynaforms and work great.

However in output documents these are shown as YYYY-MM-DD hh:mm:ss which I cant have showing in various contracts :(

I understand that i could use a trigger to set the format of date variables before I generate the contract - but i only know how to do this for single variables, and not within a grid.

In short, I need grid dates to show as DD/MM/YYYY in output documents.

Is there a simple solution to this?

I've also tried adding javascript but this doesn't seem to get executed before HTML2PDF.

I've attached photo example.

Many thanks!
Daniel

Re: Output Document Date Format from Grid

Posted: Mon Jan 28, 2019 10:55 pm
by amosbatto
If you have configured the datetime fields in your Dynaform to display the date correctly, then in your Output Document template, you need to use @#variable_label instead of @#variable for those datetime fields.

For example, if the ID of your datetime field in the grid is "startDate", then use: @#startDate_label

Re: Output Document Date Format from Grid

Posted: Tue Jan 29, 2019 6:01 am
by danielwalters
Thanks Amosbatto!
This worked. :D

Re: Output Document Date Format from Grid

Posted: Thu Apr 22, 2021 2:48 am
by hendrick
:D :D Thanks Amos, it helps me too. Cheers