Change column format from General to Date

[qliky88]

Hi Experts, 

I have a column in my data set that Qlik has recognized as General, however I want to convert it to Date. 

The column is in MMM/DD/YYYY hh:mm:tt (e.g. Apr 4 2008 4:00AM) and I want to convert it to DD/MMM/YYYY format. Have tried a few variations of the screenshot attached but to no avail. Any ideas where I'm going wrong? Should I be converting it in the load script? 

Thanks 🙂

[Kushal_Chawda]

@qliky88  Can you show screenshot of few values?

[qliky88]

Hi @Kushal_Chawda thanks for your help with this. See attached 

[Usama]

Hi,
Try this:
Date(Date,'DD/MMM/YYYY') as Upd_date

Thanks,
Usama

[arulsettu]

Maybe like this

Date(Date#('Mar 25 2008 4:00AM','MMM DD YYYY hh:mmtt'),'MMM/DD/YYYY')

[Kushal_Chawda]

try below

=date(floor(timestamp#(Date,'MMM D YYYY hh:mmTT')),'DD/MMM/YYYY')

[qliky88]

Thanks everyone for their replies, 

@Kushal_Chawda  was the closest to getting it. I inserted your formula into the load script but it seems to now only return one date?! 

Very unusual error if anyone could point me in the right direction I would really appreciate it ! 

[Kushal_Chawda]

@qliky88 

Assuming you have put down the formula in load script correctly. If so I don't think any chances of getting error. It might be that all time field values don't have same format due to which only few are getting converted

LOAD *,

          date(floor(timestamp#(YourTimeField,'MMM D YYYY hh:mmTT')),'DD/MMM/YYYY') as Date

FROM table;

[qliky88]

@Kushal_Chawda 

See below. Its a tricky one 😛 If I resolve I will post any updates here. Thanks everyone 🙂 

[Kushal_Chawda]

@qliky88  Can you check that CAPA_CLOSE_DATE coming from source has same format for all values ?