Add separator between month and year

[alexrffl]

Hello all,

I have a problem with an integer date column.

The dates are displayed as follows (Example):
12020
102019

I would like to have it like this (Example):
01.2020
10.2019

I have already converted the column as a string and tried to get it to work with the String Replacer, but can’t get it to work.

Does anyone have any ideas??

Thanks in advance!

Best regards
Alex

[lelloba]

Hello @alexrffl ,

try this:

Separate year and month – lelloba

Have a nice day,
Raffaello

[ArjenEX]

Hi @alexrffl

You can achieve this in a Column Expression with:

padLeft(substr(column("column1"),0,length(column("column1"))-4),2 ,0) + "." + right(column("column1"),4)

It takes the string excluding the year, pads a zero to create a two digit month and adds the year again.

[alexrffl]

It works! Thank you very much!