Trying to associate a date field DD/MM/YYYY with a... - Qlik Community

Martijn_M · ‎2021-09-05

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

PrashantSangle · ‎2021-09-05

You have to make it in one common format

for timestamp value you can use combination floor() & date()

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Martijn_M · ‎2021-09-06

Could you please show in code what you want me to do?

I was trying this:

Date(Date#(left(trim(DATETIME),8),'MMDDYYYY'))

Trying to associate a date field DD/MM/YYYY with a date/time field DD/MM/YYYY+Time