Crosstable DATE

[#1]

Hi,

I am loading two tables on data onto QV, the first load is a standard load where for the date I have as follows:

DATE(DATE) as DATE,

MONTH(DATE(DATE)) as MONTH,

WEEK(DATE(DATE)) as WEEK,

YEAR(DATE(DATE)) as YEAR,

The second load requires a crosstable load as my data isn't linear. However I cannot seem to get that DATE to correlate properly.

I have tried the following:

DATE#(DATE) as DATE,

MONTH(DATE#(DATE)) as MONTH,

WEEK(DATE#(DATE)) as WEEK,

YEAR(DATE#(DATE)) as YEAR,

and seen as the above didnt work I added a calculated dimension to my Chart but to no avail:

=date(<date filed>,'DD/MM/YYYY')

Could anyone recommend the Correct way to load the DATE for this Crosstable so that it correlates with the 1st load?

Thanks in advance.

Please find the attached

[swuehl]

Please note that Date() function formats the first parameter as date type according the standard date format or the format code given in second parameter.

Date#() function will evaluate or parse the expression as date using the format code. It is used to parse in strings as dates, but the format given to the function must match the actual format used in your input table.

Crosstable loads will transform field names to field values, so depending on your DATE being a qualifier field or an attribute field, you won't get a QV link between identical field names (because their might no field named DATE after your crosstable load). But I can't tell from your code snippet, so please post you complete statements, not just some line inbetween.