how to create two separate date and time column

[sharatj1989]

how to create two separate date and time column when we having date and time record in one column like (201801021700)

[sunny_talwar]

Try this

Date(Floor(TimeStamp#(DateTimeField, 'YYYYMMDDhhmm'))) as Date,

Time(Frac(TimeStamp#(DateTimeField, 'YYYYMMDDhhmm'))) as Time,

[sharatj1989]

Yes its working.

thank you sunny talwar..

[OmarBenSalem]

date(date#(left(YourField,8),'YYYYMMDD')) as DateField,

time(time#(right(YourField,4),'hhmm'),'hh;mm') as TimeField,

[OmarBenSalem]

I think sunny's approach would be better (sorry, havn't seen it ! )

[sharatj1989]

omar thanks for the answer, am beginner to qlikview both queries help me a lot.

[sunny_talwar]

I think both the approaches are the same... I don't think there is any better way... it is just a matter of preference