strange behavior of datafield

[beck_bakytbek]

Hi Folks,

i got a Question: my datafield does have a strange behavior: 

my Datefield has this content: 15.06.2019 and after Transformation: i have 2019 06 but it will be not recognized as data field and by concatenation i have such results: 201906, but if i have use the function: text(Datefield) so then i have this

right Expression: 2019 06.

Can anybody explain me or give a guide how to resolve this issue?

Thanks a lot

Beck

[Anil_Babu_Samineni · Accepted solution]

May be

Date(Date#(datefield, 'DD.MM.YYYY'), 'YYYY MM') as datefield

[beck_bakytbek]

Anil_Babu,

thanks a lot for your time and help