Extract Date from Misc. Excel Column

[#1]

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?

[Miguel_Angel_Baeyens]

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

[#3]

Hello Miguel,

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

[Miguel_Angel_Baeyens]

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