Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

Date field

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.

Capture.PNG

Thanks for your help.

11 Replies
Not applicable

Hi,

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

Example:

=date(ReloadTime())

Regards,

Marouen

sunny_talwar

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
master_student
Creator III
Creator III
Author

from timestamp into date 'DD/MM/YYYY'

master_student
Creator III
Creator III
Author

Hi Marouen,

Please see the result when I did as you recommended

in the script : Date(LASTUPDATE) AS Date_Balance

Capture.PNG

Any suggestion please?

sunny_talwar

What would 406735040 correspond to in date?

sunny_talwar

Is this right?

Capture.PNG

florentina_doga
Partner - Creator III
Partner - Creator III

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