Re: Timestamp - Qlik Community

neha_sri · ‎2014-09-16

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

tresesco · ‎2014-09-16

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

senpradip007 · ‎2014-09-16

Use this:

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

PrashantSangle · ‎2014-09-16

Hi,

Use Year(DatefieldName)

Or

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

or

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

MayilVahanan · ‎2014-09-16

Hi

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

PrashantSangle · ‎2014-09-16

Hi,

Change in Subfield() logic as

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-09-16

dat:

load * Inline

[

d

13-Mar-2013 11:00:00

];

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