topic Date field in QlikView

Date field

master_student — Tue, 14 Jun 2016 10:28:32 GMT

Hello dear community,

I have a date field format timestamp. How to convert it into Date 'DD/MM/YYYY' I need to convert it in the script.

Thanks for your help.

Re: Date field

Tue, 14 Jun 2016 10:32:44 GMT

Hi,

you can just use Date( "your date field" )

Example:

=date(ReloadTime())

Regards,

Marouen

Re: Date field

sunny_talwar — Tue, 14 Jun 2016 11:18:49 GMT

Check these link out to convert Unix date to date:

IT Walk Thru: QlikView Expression for Converting Unix int Epoch Dates to date

UNIX DATE to Qlikview DATE

Re: Date field

sunny_talwar — Tue, 14 Jun 2016 11:19:38 GMT

Here is a link from outside QlikView where you would see what your date corresponds to:

Epoch Converter - Unix Timestamp Converter

Re: Date field

MayilVahanan — Tue, 14 Jun 2016 11:23:10 GMT

What's your expected result

Re: Date field

master_student — Tue, 14 Jun 2016 11:41:23 GMT

from timestamp into date 'DD/MM/YYYY'

Re: Date field

master_student — Tue, 14 Jun 2016 13:10:11 GMT

Hi Marouen,

Please see the result when I did as you recommended

in the script : Date(LASTUPDATE) AS Date_Balance

Any suggestion please?

Re: Date field

sunny_talwar — Tue, 14 Jun 2016 13:13:17 GMT

What would 406735040 correspond to in date?

Re: Date field

sunny_talwar — Tue, 14 Jun 2016 13:16:17 GMT

Is this right?

Re: Date field

florentina_doga — Tue, 14 Jun 2016 13:30:59 GMT

pls try this

load *,

date(left(aa,5),'DD-MMM-YYYY') as date,

time(num('0.'&right(aa,4)),'hh:mm:ss') as time;

load * inline [aa

406735040

406735055];

Re: Date field

master_student — Tue, 14 Jun 2016 13:32:33 GMT

Yes.

An other date field in my database that need to be converted , the actual format is MM/DD/YY

The expected result is DD/MM/YYYY

Thanks for your help.

Re: Date field

tamilarasu — Tue, 14 Jun 2016 13:51:42 GMT

Hi,

For your first question,

1). Date(Timestamp(DateField/86400+25569),'DD/MM/YYYY')

Second question.

2) Date(Date#(DateField,'MMDDYY'),'DD/MM/YYYY')