Dates are showing incorrect

[#1]

Hi,

I have a list box with Date. The values are showing fine upto 2013/09/28 but afterwards yit is showing 41564.44683923 and so on.

again after 41564.------  it is showing multiple times the below dates

2013/09/30, 2013/10/01

Could anyone let me know why it is happening.

Thanks.

[#2]

Please help

[saumyashah90]

Hey Amelia,

I would first suggest you to assemble certain tables

Payment Plan

Cashbook Acc

Link

Enquiry Event

Creditor Votin

based on Enquiry ID

and whole table you left join it with Creditor Claim

[saumyashah90]

For more assistance:

One having all enquiry Id,keep it as a left most table and left join all other tables to it.

[#5]

Hi,

Could you please send a example of how to link the tables in order which you showed

Thanks.

[saumyashah90]

Suppose Enquiry Event is a table which consist all EnquiryID

then

EnqId:

left Join(Enquiry Event)

Load * resident Payment Plan;

left Join(Enquiry Event)

Load * resident Link;

etc

[#7]

Please help me in changing script which I attached in last reply

[saumyashah90]

Please write a script which i mentioned above doing left join for all the tables i mentioned

[#9]

HI,

Thanks,for more clear you mean I need to write Left Join instead of Concatenate in Link table?

[saumyashah90]

yeah correct.

And please follow the syntax properly

[#11]

Please could you send the order of tables please Saumya as I am really struggling this.

Thanks.