your month data is in text format , that why we need to use num#() and not the date#
Date#
date#(expression [ , format-code ])
The date# function evaluates the expression as a date according to the string given as format-code. If the format code is omitted, the default date format set in the operating system is used.
Examples:
The examples below assume the two following operating system settings:
Default setting 1
Default setting 2
Date format
YY-MM-DD
M/D/YY
date#( A ) where A=8/6/97 returns:
Setting 1
Setting 2
String
8/6/97
8/6/97
Number
-
35648
date#( A, 'YYYY.MM.DD' ) where A=1997.08.06 returns:
The num# function evaluates the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the default number format set by script variables or in the operating system is used.
Examples:
The examples below assume the two following operating system settings:
Default setting 1
Default setting 2
Number format
# ##0,#
#,##0.#
num#( A, '#' ) where A=35,648.375 returns:
Setting 1
Setting 2
String
35,648.375
35648.375
Number
-
35648.375
num#( A, '#.#', '.' , ',') where A=35,648.375 returns:
Setting 1
Setting 2
String
35,648.375
35,648.375
Number
35648.375
35648.375
num#( A, '#.#',',','.' ) where A=35648.375 returns:
At what point of time in your script execution are you trying to parse the date?
Could you post your script?
As I said above, the CROSSTABLE will transform all column labels to text, and the column label is a textual number like 41030 when read from excel. so trying to interpret it with a date format will not work.
