topic Re: Problems with makedate function in QlikView

Problems with makedate function

Tue, 12 Jun 2012 09:26:54 GMT

Hello,

Can someone help me to create a date field. I have attached the data from this field. I tried the makedate function with no result.Also I tried the left function but then I got numbers instead of a dates.

with kind regards,

Aissam

Re: Problems with makedate function

deepakk — Tue, 12 Jun 2012 09:33:26 GMT

hi,

Can you attach some sample data or application. I am not able to open the application.

Deepak

Re: Problems with makedate function

christophebrault — Tue, 12 Jun 2012 09:34:06 GMT

Hi,

to transform a date field, use date() function like this :

In a text box this expression gives 01/06/2010:

=date(date#('01-06-2010 00:00:00','DD-MM-YYYY hh:mm:ss'),'DD/MM/YYYY')

if you want to use this syntax in your script, write :

date(date#(YourDateField,'DD-MM-YYYY hh:mm:ss'),'DD/MM/YYYY')

Note that date format ('DD/MM/YYYY') depends on your Set Variable at the begining of your script.

Re: Problems with makedate function

Tue, 12 Jun 2012 09:55:05 GMT

Hello,

No results with this script. I have attached the file.

regards,

Aissam

Re: Problems with makedate function

deepakk — Tue, 12 Jun 2012 10:16:31 GMT

HI Aissam,

You can try out the below code

makedate(mid(trim(redSheet_date),7,4), mid(trim(redSheet_date),4,2) , left(trim(redSheet_date),2))

Its little weird. Inside a the listbox I formatted the date and it worked fine. I used Date(redSheet_date,'DD-MMM-YYYY') and it worked fine.

Deepak

Re: Problems with makedate function

Tue, 12 Jun 2012 11:15:42 GMT

Hi,

I worked on your attached application, its working fine with "date(redSheet_date)"to create date in front end ,i hope it will work in backend also.

I have generated the date field in front end in your app, that i have attached below.

Please refer.

I hope this will resolve ur problem.

Re: Problems with makedate function

Tue, 12 Jun 2012 11:38:19 GMT

thanks guys...

with kind regards,

Aissam