topic AW:How to change textfield into datefield? in QlikView

How to change textfield into datefield?

Mon, 14 Dec 2009 19:07:22 GMT

Hi there,

I'm new here and I have a question on how I can change a textfield:"Open.date" into a datefield from a .txt file?

The textfield looks like "01.12.2009" and is downloaded as a flat file from SAP R6.

Part of the script below;

LOAD

Notification,

[Desc. of Cost],

Costpl.

as Cost,

Open.date

as Notificationdate,

FROM

(

txt, codepage is 1252, embedded labels, delimiter is '|', header is 3 lines, no eof, filters(

Remove

(Col, Pos(Top, 1)),

Remove

(Row, Pos(Top, 2)),

Remove

(Col, Pos(Top, 17))

))

;

can anyone help me with this?

AW:How to change textfield into datefield?

Mon, 14 Dec 2009 19:19:15 GMT

Hi,

try it with

date#(Open.date,'dd.mm.yyyy')

Alex:)

How to change textfield into datefield?

Mon, 14 Dec 2009 19:38:13 GMT

markbeenders, i don't know from which database you are pulling information from but if you are using sql server, u just have to convert it there before pulling the information

e.g select convert(date,'01.12.2009') as 'datefield'

AW:How to change textfield into datefield?

Mon, 14 Dec 2009 20:34:17 GMT

Thx alex,

This works fine!

Mark Beenders