topic Re: Date Format Not Working in QlikView

Date Format Not Working

Anonymous — Mon, 14 Dec 2015 09:08:36 GMT

Hi,

I have a question about converting date format in load script.

I have a data like this:

i want to convert the data into this format : dd-MM-yyyy

I've try using this date() function like this in load script

--> Date(Floor(Date#(Trim(MyDATE), 'YYYY/MM/DD hh:mm:ss')), 'dd-MM-yyyy')

but it returns null

Any idea to solve this problem ?

Really appreciate your help, thanks

Re: Date Format Not Working

tresB — Mon, 14 Dec 2015 09:11:01 GMT

Try like:

Date(Floor(Num(Trim(MyDATE))), 'dd-MM-yyyy')

Re: Date Format Not Working

robert_mika — Mon, 14 Dec 2015 09:12:10 GMT

Try use floor first

date(floor(MyDATE),'DD-MM-YYYY') AS CalendarDate

Re: Date Format Not Working

Peter_Cammaert — Mon, 14 Dec 2015 09:14:33 GMT

DayStart(MyDATE)

QlikView should automatically recognise your field values as numbers, and dates/times/timestamps are numerical values anyway. If possible, let QV do the work.

Peter

[Edit]: I'm assuming that your default date format string (DateFormat) already has the correct value 'DD-MM-YYYY'

Re: Date Format Not Working

manojkulkarni — Mon, 14 Dec 2015 09:19:46 GMT

you just use Date() function to convert into required format.

Date(42303.56960,'DD-MM-YYYY') it worked for me

Re: Date Format Not Working

jagan — Mon, 14 Dec 2015 09:20:04 GMT

Hi,

Try like this

LOAD

Date(Floor(MyDATE), 'DD-MM-YYYY') AS Date_Formatted

FROM Datasource;

Hope this helps you.

Regards,

jagan.

Re: Date Format Not Working

tamilarasu — Mon, 14 Dec 2015 09:20:20 GMT

Simply try,

Date(Floor(42303.565960648),'DD-MM-YYYY')

Date(Floor(MyDATE),'DD-MM-YYYY') as MyDateNew

Re: Date Format Not Working

buzzy996 — Mon, 14 Dec 2015 09:24:19 GMT

looking for this,

Re: Date Format Not Working

ahmar811 — Mon, 14 Dec 2015 09:34:36 GMT

Try this

Date(Floor(Trim(MyDATE)), 'DD/MM/YYYY') as NewMyDate

hope this help you

Thanks & Regards

Ahmar

Re: Date Format Not Working

Anonymous — Mon, 14 Dec 2015 10:24:33 GMT

Hi Guys,

thanks for all suggestion. It solve my problem perfectly.

Once again, thanks in advance