cancel
Showing results for 
Search instead for 
Did you mean: 

Formatting date in Layout Designer

Former Member
0 Kudos

Hi all, I have to print a check and the payment document (pull from a variable field) shows the date as YYYYMMDD and I need this formatted as YYYY/MM/DD just using PLD

Any idea??

Thanks

Lucas

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi Lucas Ritondale

Check them in the system Initialization.

Former Member
0 Kudos

Hi Sandeep, I have date formated with the "/" separator in the system initialization. That is the problem, in the check the date appears without this separator as 20060614. And I wanted to know if I can format this throught PLD

Thanks

Lucas

Former Member
0 Kudos

What you can do is to create a hidden field and assign the system variable to it. Change the current date field to a formula and insert the following function:

Concat(Year(Field_348),"/",Month(Field_348),"/",Day(Field_348)) where Field_348 is hidden system variable field.

Answers (0)