Date Joining failing

[mhappiee]

Hi

 I have 3 tables  which has order time and extracted date from the same  and trying to join the 3 tables based on date with/With out master calendar but it is not properly joining , what might be the reason, can somebody help me trace where am i Going wrong?

Note: used floor , date , formats are same 

Regards,

Happiee

[West]

You can't join these 3 tables just via "date". You need to specify the connections among order amount, past order id, and order No. There has to be a one-to-one relationship, or you will end up with a table like this.

[mhappiee]

Hi,

Unfortunately I do not have any primary key to connect the data sets ,but trying to join them to compare the data sets side by side based on date . so there is no other possibility ?

Regards,

imhappiee

[vinod22kv]

Hi,

Please check the date field. if it has minits and seconds it is not posible to make joint use flore function to remove the time in the data and make the joint.

hope your format is like :dd-mm-yy hh:mm:ss" make this in to  dd-mm-yy It will work.  🙂