Date(Floor(TimeStamp#(DateTimeField, 'YYYYMMDDhhmm'))) as Date,
Time(Frac(TimeStamp#(DateTimeField, 'YYYYMMDDhhmm'))) as Time,
Yes its working.
thank you sunny talwar..
date(date#(left(YourField,8),'YYYYMMDD')) as DateField,
time(time#(right(YourField,4),'hhmm'),'hh;mm') as TimeField,
I think sunny's approach would be better (sorry, havn't seen it ! )
I think both the approaches are the same... I don't think there is any better way... it is just a matter of preference
omar thanks for the answer, am beginner to qlikview both queries help me a lot.
Retrieving data ...