topic Timestamp conversion in QlikView

Timestamp conversion

Fri, 29 Jan 2016 05:31:04 GMT

Morning,

I would like to convert the following date to YYYYMM but am struggling to find the right format:

31JAN2015:00:00:00

I have searched on the community but have not come across the right example. Has anyone converted this type of timestamp yet?

Thank you,

Re: Timestamp conversion

Anonymous — Fri, 29 Jan 2016 12:30:04 GMT

Is it coming from Field or just this value only?

You may try like this?

=date(date#(YourField, 'NativeFormat'),'RequiredFormat')

Re: Timestamp conversion

sunny_talwar — Fri, 29 Jan 2016 12:37:21 GMT

May be try this:

Date(MonthStart(Date#(Left(Trim(TimeStampField), 9), 'DDMMMYYYY')), 'YYYYMM') as TimeStampField

Re: Timestamp conversion

settu_periasamy — Fri, 29 Jan 2016 12:38:20 GMT

Hi,

Try this..

=Date(Date#('31JAN2015:00:00:00','DDMMMYYYY:hh:mm:ss'),'YYYYMM')

Re: Timestamp conversion

sunny_talwar — Fri, 29 Jan 2016 12:42:02 GMT

I would suggest using MonthStart or MonthEnd because if you don't then may be you still see YYYYMM, it would still show up as multiple entries in list box or straight table because the date can still be different. With MonthStart we will essentially making all the dates within that month equal to 1.

Re: Timestamp conversion

settu_periasamy — Fri, 29 Jan 2016 13:17:11 GMT

Thanks sunindia‌ Noted. i will keep it..

Re: Timestamp conversion

Sun, 31 Jan 2016 15:15:15 GMT

Thank you Sunny That worked perfectly!

Re: Timestamp conversion

sunny_talwar — Sun, 31 Jan 2016 16:00:58 GMT

Not a problem. I am glad I was able to help