Date# returns correct number, Date() isn't parsing it

[#1]

Hi all,

I have the following lines in my script:

Date(Date#(LastCallDate, 'DD/MM/YYYY h:mm:ss tt')) as CalendarDate,

Date#(LastCallDate, 'DD/MM/YYYY h:mm:ss tt')) as NumberDate,

LastCallDate

CalendarDate doesn't work

When I display it in a TableBox, it shows only a '-' in the CalendarDate field. The LastCallDate is shown correctly and NumberDate is also correct. I have no clue how to proceed.

I've included a picture that shows what I mean.

I hope that somebody can show me what's wrong with this, I've been trying different things now for more than an hour.

I have Qlikview 11, 64-bit version.

Thanks in advance!!

[#2]

Hi swuehl,

This makes things a bit clearer, thank you.

I've checked by making a graph-table and you are right, doing Num#(OnlyDate) is indeed just the textual representation. Only Num#(CalendarDate) is actually returning a number.

I must say, this is more confusing than I thought it would be

[Miguel_Angel_Baeyens]

Hi Matt,

It may be confusing, but consider the "#" functions as interpretation functions (change the format you get from the datasource and put into memory) and the "normal" functions as representation functions (OK, you have a date that keeps its original value but, how do you want to show it?). Check this thread for further examples and meaning on representation and interpretation.

Hope that helps.

Miguel