topic Date problem in QlikView

Date problem

Wed, 17 Aug 2011 14:22:43 GMT

Hi All,

I have some problem i am new in qlikview and when i load my data it comes in 40512 some thing like that but in the excel sheet it is in date format.

How to handle this please some one provide help.

Jude

Date problem

Wed, 17 Aug 2011 14:31:48 GMT

Hi,

Try the following

Date(D,'DD-MMM-YYYY') or Date#(D,'DD-MMM-YYYY')

Here D will be your date field name.Let me know if you have any further queries

Re: Date problem

its_anandrjs — Wed, 17 Aug 2011 14:36:22 GMT

Hi,

You need to convert your field into date by the code Date(YourDateField) as DateField. By the help of this you convert it into Date type.

Regards

Date problem

Wed, 17 Aug 2011 14:38:23 GMT

Hi,

You can also write :

Date([YourDate])

The format will be the format of your regional setting. (ex: 17/08/2011)

Put an alias after the instruction in your script to a better understanding in your application:

Date([YourDate]) as ProductDate, //For example

Date problem

Wed, 17 Aug 2011 14:46:02 GMT

Hi,

There is some problem when i put Date(extDate) as Newdate some wrong dates are comes in the list but it is not there. Why this is comes.

Jude

Date problem

jagannalla — Wed, 17 Aug 2011 14:46:27 GMT

I think your displaying that field in listbox or tablebox or in any sheet object. If you used those field in any object. Then right click on object->properties->Number Tab

select date or timestampand give timeformat what you want like below images:

Re: Date problem

its_anandrjs — Wed, 17 Aug 2011 14:53:44 GMT

Hi,

I thing you need to clean the dates it comes due to different values try to clean it if you have any sample file so provide me.

Regards

Anand

Re: Date problem

Wed, 17 Aug 2011 14:58:24 GMT

Hi,

See my attached sample file in that some wrong dates are comes why this so.

Jude

Date problem

jagannalla — Wed, 17 Aug 2011 15:03:27 GMT

sorry in my reply..one of my image has taken with Time format. Please take there Date format...

May be it helps you.. Even if you unable to solve your problem plz attach your file.

Re: Date problem

its_anandrjs — Wed, 17 Aug 2011 15:06:31 GMT

Hi,

Try to put a new date field to be loaded in script editor with following code If(Len(extDate)=5,Date(extDate)) as NewDate field. With the helps of this your Date field will be clean.

Regards,

Anand

Re: Date problem

Wed, 17 Aug 2011 15:16:00 GMT

Hi,

Correct it works for me thanks.

Jude