Conversion of date in PLD

[Former Member]

Good day,

I'd like to convert the format of the date in PLD. Is there anyone who knows how to do that? Please see attached file.

Sample format (mm/dd/yyyy, dd.mm.yy or yyymmdd)

Thank you.

Regards,

Ardie

[Former Member · Accepted solution]

Hi,

  Try with Date format in General settings.

Otherwise you need to try with formula like Day(),Month(),Year(). then concatenate it as you like. But it is complicated in the row level .

[Former Member · Accepted solution]

Thank you for your reply. I just need to change the date format in PLD without changing the format in General setting. Do you think concatenating is the only option for this? Thank you.

Regards,

Ardie

[KennedyT21 · Accepted solution]

Hi Ardie Trinidad

our Actual Date field --- Field_100

Create 4 Formula field and 1 Free Text

  F_101

F_102

F_103

F_104

F_105

Now In The

F_101 formula          Day(Field_100)

F_102 formula         Month(Field_100)

F_103 formula         Monthname(Field_102)

F_104 formula         Year(Field_100)

F_106 freetext   /  

date seperator your wish(/ or .)

F_105 formula      Concat(F_101,F_106,F_103,F_106,F_104)

Hide the fields

F_101

F_102

F_103

F_104

F_105

Hope you understand.

Regards

Kennedy

[Former Member · Accepted solution]

Yes, There is no other option for this.

I did the same one of my PLD.

[Former Member]

Thanks for your help. It really works.

[Former Member]

Hi Ardie,

Change date format in PLD level is too cumbersome. Why cant be on db level?

Thanks,

Gordon

[Former Member]

HI

Best way to change date format in PLD is  try with formula like Day(),Month(),Year(). then concatenate it as you like.

For e.g

F_10 formula          Day(Field_100)

F_11 formula         Month(Field_100)

F_12 formula         Monthname(Field_102)

F_13 formula         Year(Field_100)

F_13 formula        Free Text

and use Concatenate function

But it is complicated in the row level .