dates issues

[#1]

Hi guys i'm experiencing a strange proble with the dates.

I have created a calendat using one of the multiple example found into this forum.

On the other side I load valued from an Excel file where dates are stored as numeric value and displayed using date format (cell propertie).

So when i load the XLS file i have this code :

Date([Submitted On]) as SDate,

1 as cpt

and on the calendar side i have

Date(TempDate) AS SDate,

Month(TempDate) AS SMonth

Qlikview link correctly the 2 columns, but the problem occurs when i try to make table using columns from this 2 tables.

For example i try to create a table displaying the columns : Category / SMonth / Sum(Cpt)

The table displays columns Category and Sum correctly at the beginning of the table and columns SMonth contains '-', then when the values from columns Category/Sum(cpt) are ended, table displays the values of SMonth and '-' for the 2 others columns.

I really don't understand why this occurs.

Thanks for your help.

[#2 · Accepted solution]

Solution found here :

http://rhyous.com/2010/01/14/why-does-the-calendar-date-field-and-the-date-field-of-some-other-table...

Date(Round(DateAsDoubleValue - .5, 1)) as CalendarDate,