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]

Hi,

I used Left Join instead of Concatenats in Link table. It's showing only EnquiryID and all Staright/ Pivot tables and all list boxes are showing empty. Please help me as I am really confusing and I suppose I am doing entirely wrong in script. Please help.

[Arthur_Fong]

Hi Amelia D,

Format your date correctly. For example, standardizing all dates to only use number formats.

The syntax of doing this is : num(Date(<DateField>)).

Next, you have to ensure that you have the correct key used in joining all the tables.

If the tables are joined correctly, you should not have null values in the front end.

Thanks and regards,

Arthur Fong