Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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 ];
YES! it's correct, works very good.
thank's for your post. I Close the issue.
Greatings!
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 |
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 ];
YES! it's correct, works very good.
thank's for your post. I Close the issue.
Greatings!