topic Re: Format date in QlikView

Format date

penpayom — Wed, 01 Aug 2018 02:21:14 GMT

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

Output

MarioCenteno — Wed, 01 Aug 2018 02:38:34 GMT

Try

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

Anonymous — Wed, 01 Aug 2018 02:49:51 GMT

Try this:

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

Anonymous — Wed, 01 Aug 2018 05:12:04 GMT

can you try

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

BalaBhaskar_Qlik — Wed, 01 Aug 2018 06:42:27 GMT

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.