Difference between Timestamp and Timestamp#

[pgarcia75]

Hello

I'm new with QlickView, and I trie to load a field from CSV file. The field is under the format 'DD/MM/YYYY mm:hh'

What the difference with timestamp(XX) and timestamp#(XX) in the script to load file ?

The result is different, when I trie to compar date loaded with date of the day

Thank for the response

P

[brenner_martina]

Hi,

Timestamp#() means, that QV interpret the format from the source like you need, p.e.

Timestamp#('20110512 08:22','YYYYMMDD hh:mm') As Timestamp or

Timestamp#('05-12-2011 08.22:32','MM-DD-YYYY hh.mm.ss') As Timestamp

And Timestamp() means the default format you wish to be shown in your application

Timestamp('12-05-2011 08:22','DD.MM.YYYY hh:mm') As Timestamp

often you need to combine both functions

Timestamp(Timestamp#('20110512 08:22','YYYYMMDD hh:mm'),'DD.MM.YYYY hh:mm') As Timestamp

[pgarcia75]

Hi

Thanks for the response

In complement, if in my script, I have

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

...

LOAD

..

     Timestamp#([Heure d'ouverture]) as [Open_Incident],

In a Chart Objet, the  expression : count({1<Open_Incident={">=$(=MonthStart(AddMonths(now(2),-3)))"}>}[ID Incident]) return datas

When I have

     Timestamp#([Heure d'ouverture],'DD/MM/YYYY hh:mm') as [Open_Incident],

In a Chart Objet, the  expression : count({1<Open_Incident={">=$(=MonthStart(AddMonths(now(2),-3)))"}>}[ID Incident]) return non data

Can you explain why ?

Thanks

P