Date Format - Timestamp

[#1]

Dear Friends,

I am using QV file linked with Excel workbook having one of the field as Date.

Some dates in this column are in DD/MM/YYYY format while few are DD/MM/YYYY hh:mm:ss format.

In QlikView file, in one of the table I am having this field.

In this field, date is displayed based on condition as it is linked with Variable Date selection.

This selected date appears in DD/MM/YYYY format.

Query:

When I convert All Dates in Excel file in DD/MM/YYYY format, it works properly.

If there are mixed formats, it doesn't work.

In Script, I tried function

DATE([date],'DD/MM/YYYY') as Date

Still it didn't work.

Please contribute your knowledge to resolve this issue.

Thanks.

[#2]

Hi,

Sorry, even above code didn't succeed.

[Miguel_Angel_Baeyens]

Hi,

Then use the following

Table:
LOAD
     Date(Floor(Date)) AS DateQryReply,
...
FROM File.xls

This is working fine here, but it will depend on your excel raw data.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#4]

Hi,

Sorry,

even this code gives blanks. Neither dates nor values.

[Miguel_Angel_Baeyens]

Hello,

Then that makes me assume that your excel file has some issue when being read by QlikView. Can you post some sample rows so we can check it? I tried yesterday with a simple excel file and different date formats and the load was fine.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#6]

Ravi,

Try it directly in the script. What Miguel has suggested should work.

Date(Floor(ExcelDateField)) as DateQryReply

Nimish

[#7]

Ravi,

Try it directly in the script. What Miguel has suggested should work.

Date(Floor(ExcelDateField)) as DateQryReply

Nimish