Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have a problem with data format.
After the setting in data manager, i cannot view the field in a table of analysys (see 3 images in attachment)
How can I solve it?
Thank you, Gabriele.
Hello Gabriele,
Can you change it so the input format is 'DD/MM/YYYY'?
Seems you are setting the input format to a format that doesn't match the field contents.
I hope that helps!
Kind regards,
S.T.
Try explicitly format the date on the load script
Load
DATE(FLOOR(CRMData),'DD/MM/YYYY')
.......