Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems with makedate function

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

6 Replies
deepakk
Partner - Specialist III
Partner - Specialist III

hi,

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

Deepak

christophebrault
Specialist
Specialist

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.

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Not applicable
Author

Hello,

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

regards,

Aissam

deepakk
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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.

Not applicable
Author

thanks guys...

with kind regards,

Aissam