Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to associate 2 tables with each other, using the date fields as connection. But one field also contains time after the date and i am struggling to link the 2 together. Should I first use the TRIM function and the rename them so that they ]are linked? I have added a picture of the two fields in my datamodel.
Thank you guys in advance!
Kind regards,
Martijn
You have to make it in one common format
for timestamp value you can use combination floor() & date()
Regards,
Prashant
Could you please show in code what you want me to do?
I was trying this:
Date(Date#(left(trim(DATETIME),8),'MMDDYYYY'))