topic Re: date and Date# function in QlikView

date and Date# function

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

I am getting error while working on date(date#,format) function , any body could give me the help on this please.

Re: date and Date# function

sunny_talwar — Wed, 04 Jan 2017 17:02:37 GMT

What is the expression you are using?

Re: date and Date# function

Thu, 05 Jan 2017 14:02:09 GMT

I have taken date field as expression.

I am using it at script level like

date(date#(datefield,'M/D/YY'),'YYYY/MM/DD')

Re: date and Date# function

sunny_talwar — Thu, 05 Jan 2017 14:06:01 GMT

What is the error that you get when you use this? I don't see anything wrong with the syntax

Re: date and Date# function

Thu, 05 Jan 2017 14:12:02 GMT

Hi Sunny,

data not loading into that field

Re: date and Date# function

sunny_talwar — Thu, 05 Jan 2017 14:19:20 GMT

Can you show how datefield look in its raw form?

Re: date and Date# function

Thu, 05 Jan 2017 14:44:36 GMT

Hi Sunny,

This is my data

LOAD DEPARTMENT_ID,

EMPLOYEE_ID,

END_DATE,

JOB_ID,

date(date#(START_DATE,'yyyy/dd/mm'),'yy/d/m/') as daa

FROM

E:\ALL_HR_8_TABLES_DETAILS_VIEW.xls

(biff, embedded labels, table is [JOB_HISTORY$]);

Re: date and Date# function

sunny_talwar — Thu, 05 Jan 2017 14:47:14 GMT

Two things...

1) why do you have an extra / at the end here? Typo?

2) Month is MM (upper case m) and Minute is mm (lower case m)

Try this

LOAD DEPARTMENT_ID,

EMPLOYEE_ID,

END_DATE,

JOB_ID,

date(date#(START_DATE,'YYYY/DD/MM'),'YY/D/M') as daa

FROM

E:\ALL_HR_8_TABLES_DETAILS_VIEW.xls

(biff, embedded labels, table is [JOB_HISTORY$]);

Assuming START_DATE is like this in your Excel file -> 2017/05/01

Re: date and Date# function

Thu, 05 Jan 2017 14:55:49 GMT

Hi sunny,

Thanks for quick response.

My date format is like 'M/D/YYYY'

Re: date and Date# function

sunny_talwar — Thu, 05 Jan 2017 14:58:11 GMT

And you need it to be in YY/D/M format?

LOAD DEPARTMENT_ID,

EMPLOYEE_ID,

END_DATE,

JOB_ID,

date(date#(START_DATE,'M/D/YYYY'),'YY/D/M') as daa

FROM

E:\ALL_HR_8_TABLES_DETAILS_VIEW.xls

(biff, embedded labels, table is [JOB_HISTORY$]);

M/D/YYYY - your current format

YY/D/M - your needed format

Re: date and Date# function

Thu, 05 Jan 2017 14:58:35 GMT

Hi Sunny,

Kindly let me now how to use hierarchy load in qlikview

Thanks & regards,

Sivaramakrishna 7304499003.

Re: date and Date# function

sunny_talwar — Thu, 05 Jan 2017 15:01:08 GMT

I suggest you open a new thread for an unrelated question

Re: date and Date# function

pipuindia99 — Fri, 06 Jan 2017 06:34:20 GMT

Is this issues is solved now?

Re: date and Date# function

Fri, 06 Jan 2017 15:45:06 GMT

Hi Pradeep,

Yes

Thanks for your support

Re: date and Date# function

Fri, 06 Jan 2017 15:46:17 GMT

Hi Sunny,

Thanks for Replay

I didn't get you what you said.may i have your contact number please.