Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie2
Contributor II
Contributor II

Date Format

Hello,

Looking for help to change the following in the load script:

New_Date

1894-05-14 00:00:00.000000 

to show as:

New_Date

14-05-1894

Thank you

Labels (1)
2 Replies
AshutoshBhumkar
Partner
Partner

Hello,

Try this.

Date(Timestamp#('1894-05-14 00:00:00.000000','YYYY-MM-DD hh:mm:ss.ffffff'),'DD-MM-YYYY')

AshutoshBhumkar_0-1639388505539.png

 

Hope this helps.

Thanks,

Ashutosh

anat
Specialist II
Specialist II

LOAD *,date(Floor(dt),'DD-MM-YYYY');
LOAD * Inline [
dt
1894-05-14 00:00:00.000000

];