Date problem

[#1]

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

[#2]

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

[its_anandrjs]

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

[#4]

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

[#5]

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

[jagannalla]

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:

[its_anandrjs]

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

[#8]

Hi,

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

Jude

[jagannalla]

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.

[its_anandrjs · Accepted solution]

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