topic Extract Date from Misc. Excel Column in QlikView

Extract Date from Misc. Excel Column

Tue, 23 Nov 2010 08:14:16 GMT

Hi All,

Here is a sample attached excel file containing misc. data in date_time column.
How do we extract only date from such column?

Extract Date from Misc. Excel Column

Miguel_Angel_Baeyens — Tue, 23 Nov 2010 08:40:45 GMT

Hello Kumar,

At a first sight, I'd do something as follows in your load script

If(Index(Trim(Date_Time), '/') AND Index(Trim(Date_Time), ':'), TimeStamp(TimeStamp#(Trim(Date_Time), 'DD/MM/YYYY hh:mm:ss tt')), 'Not a Date') AS Date_Time // there is a double space between YYYY and hh

Hope this helps

Extract Date from Misc. Excel Column

Tue, 23 Nov 2010 10:25:42 GMT

Hello Miguel,

Thanks for your reply, how can we generate date list from the given date_time column ?

Extract Date from Misc. Excel Column

Miguel_Angel_Baeyens — Tue, 23 Nov 2010 11:08:06 GMT

If you mean a master calendar, check this post and this post. There are several files with code examples in the "Share QlikViews" menu, in this webpage, above.

Hope this helps