Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be
Date(Date#(datefield, 'DD.MM.YYYY'), 'YYYY MM') as datefield
May be
Date(Date#(datefield, 'DD.MM.YYYY'), 'YYYY MM') as datefield
Anil_Babu,
thanks a lot for your time and help