Date Format Not Working

[Anonymous]

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

[tresesco · Accepted solution]

Try like:

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

[robert_mika]

Try use floor first

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

[Peter_Cammaert]

or

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'

[manojkulkarni]

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

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

[jagan]

Hi,

Try like this

LOAD

*,

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

FROM Datasource;

Hope this helps you.

Regards,

jagan.

[tamilarasu]

Simply  try,

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

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

[buzzy996]

looking for this,

[ahmar811]

Try this

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

hope this help you

Thanks & Regards

Ahmar

[Anonymous]

Hi Guys,

thanks for all suggestion. It solve my problem perfectly.

Once again, thanks in advance