topic Re: Date format in QlikView

Date format

tincholiver — Sat, 16 Nov 2024 04:56:47 GMT

Hi, I make a request:

I'm reading sheets of Google Sheets and I have a problem with the format of the dates, they come in DD / MM / YYYY hh: mm: ss.
The problem is that the numbers less than 10 get zero from the left then the format is in some cases D / M / YYYY h: m: s.

I already probe with date # and alt (Date #) but I can not format the field to DD / MM / YYYY.

Suggestions ?

Thanks and regards!

Re: Date format

sunny_talwar — Mon, 17 Dec 2018 18:15:54 GMT

Can you share an image of what you have?

Re: Date format

tincholiver — Mon, 17 Dec 2018 18:22:49 GMT

some fields about...

ID	Marca_Temporal
1416	1/6/2018 9:19:23
1417	2/7/2018 12:43:20
1418	15/8/2018 2:47:59
1419	1/9/2018 2:48:18
1420	1/10/2018 12:48:34
1421	10/10/2018 12:48:53
1422	1/11/2018 12:49:52
1423	17/12/2018 12:50:09

Re: Date format

sunny_talwar — Mon, 17 Dec 2018 18:27:40 GMT

Try something like this

Table:
LOAD ID,
	 Date(Floor(Date#(Marca_Temporal, 'D/M/YYYY h:m:ss')), 'DD/MM/YYYY') as Marca_Temporal;
LOAD * INLINE [
    ID, Marca_Temporal
    1416, 1/6/2018 9:19:23
    1417, 2/7/2018 12:43:20
    1418, 15/8/2018 2:47:59
    1419, 1/9/2018 2:48:18
    1420, 1/10/2018 12:48:34
    1421, 10/10/2018 12:48:53
    1422, 1/11/2018 12:49:52
    1423, 17/12/2018 12:50:09
];

Re: Date format

tincholiver — Mon, 17 Dec 2018 18:41:06 GMT

YES! it's correct, works very good.

thank's for your post. I Close the issue.

Greatings!