topic Re: Timestamp in QlikView

Timestamp

neha_sri — Tue, 16 Sep 2014 05:48:42 GMT

Hi All,

I want to find year from this timestamp

13-Mar-2013 11:00:00 AM

how can I do so...

Thanks in anticipation

tresB — Tue, 16 Sep 2014 05:53:55 GMT

Year(TimeStamp#(Yourdate, 'DD-MMM-YYYY hh:mm: ss TT'))

senpradip007 — Tue, 16 Sep 2014 05:55:04 GMT

Use this:

Year( Timestamp#('13-Mar-2013 11:00:00 AM', 'DD-MMM-YYYY h:mm:ss TT'))

PrashantSangle — Tue, 16 Sep 2014 05:55:25 GMT

Hi,

Use Year(DatefieldName)

Subfield(DateFieldName,'-',3) as Year

Year(Timestamp#(DateFieldName,'DD-MMM-YYYY hh:mm:ss TT')) as Year

Regards

MayilVahanan — Tue, 16 Sep 2014 05:56:27 GMT

try like this

Year(floor(Date#('13-Mar-2013 11:00:00 AM','DD-MMM-YYYY hh:mm:ss tt'))) as Year

Replace date with datefield

PrashantSangle — Tue, 16 Sep 2014 06:00:14 GMT

Hi,

Change in Subfield() logic as

Subfield(Subfield(DateFieldName,'-',3),' ') as Year

Regards

Tue, 16 Sep 2014 06:31:57 GMT

dat:

load * Inline

[

13-Mar-2013 11:00:00

];

load Year(Date#(d,'DD-MMM-YYYY hh:mm:ss')) as Year Resident dat;