Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Format date

Hi

I want to Format date from YYYY-MM-DD hh:mm:ss to DD/MM/YYYY ,but some output data uncorrected ,it Show "-" 

What Happen with my date. Please help me.

thank you.


Code

1.PNG

Output

2.PNG

4 Replies
Highlighted
Creator III
Creator III

Try

Date(Date#([SO_NO_DATE],'YYYYMMDD'),'DD/MM/YYYY') as [SO_NO_DATE]

Highlighted
Contributor III
Contributor III

Try this:

Date( Floor( Timestamp#( SO_NO_DATE, 'YYYY-MM-DD hh:mm:ss')), 'M/D/YYYY') as SO_NO_DATE

Highlighted
Contributor III
Contributor III

can you try

Date(DayStart(floor([SO_NO_DATE])),'DD/MM/YYYY') as [SO_NO_DATE]

Highlighted

Use this:

DFIT_SO_HEADER:

LOAD

    SO_NO,

    SO_NO_DATE,

    DAYNAME(SO_NO_DATE) AS OPEN_ORDER,

    DATE(timestamp#(SO_NO_DATE,'MM/DD/YYYY h:mm:ss TT')) as OPEN_ORDER,

    Date(Floor(SO_NO_DATE)) as OPEN_ORDER,

    Date(Floor(Date(Date#(Left(SO_NO_DATE,Len(SO_NO_DATE)-10),'MM/DD/YYYY hh:mm:ss TT'))),'DD/MM/YYYY')

From ABC.csv;

Follow different formats to remove the extra timestamp.