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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

Date format

Hi all,

I need to show the last reload time as '01-Jan-2015 rather than 01-01-2015

Kindly advise.

Regards,

Mahamed

5 Replies
sunny_talwar

May be this:

=Date(ReloadTime(), 'DD-MMM-YYYY')


Capture.PNG

Mahamed_Qlik
Specialist
Specialist
Author

Hi Sunny,

No. It is giving me 29-3-2016.

imrencimen
Contributor III
Contributor III

by changing TimestampFormat u maybe get solution.

SET TimestampFormat='DD.MMM.YYYY';

qlik.PNG

Chanty4u
MVP
MVP

=date(Date#(relaodtime(),'DD-MMM-YYYY'),'DD-MM-YYYY')

sunny_talwar

Do you have this environmental variable when you reload your application?

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Capture.PNG