Date field

[master_student]

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.

[#2]

Hi,

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

Example:

=date(ReloadTime())

Regards,

Marouen

[sunny_talwar]

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

[sunny_talwar]

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

Epoch Converter - Unix Timestamp Converter

[MayilVahanan]

Hi

What's your expected result

[master_student]

from timestamp into date 'DD/MM/YYYY'

[master_student]

Hi Marouen,

Please see the result when I did as you recommended

in the script : Date(LASTUPDATE) AS Date_Balance

Any suggestion please?

[sunny_talwar]

What would 406735040 correspond to in date?

[sunny_talwar]

Is this right?

[florentina_doga]

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];