Date format

[tincholiver]

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!

[sunny_talwar]

Can you share an image of what you have?

[tincholiver]

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

[sunny_talwar · Accepted solution]

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
];

[tincholiver · Accepted solution]

YES! it's correct, works very good.

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

Greatings!