Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tincholiver
Creator III
Creator III

Date format

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!

Labels (1)
2 Solutions

Accepted Solutions
sunny_talwar

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

View solution in original post

tincholiver
Creator III
Creator III
Author

YES! it's correct, works very good.

 

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

 

Greatings!

View solution in original post

4 Replies
sunny_talwar

Can you share an image of what you have?
tincholiver
Creator III
Creator III
Author

some  fields about...

 

IDMarca_Temporal
14161/6/2018 9:19:23
14172/7/2018 12:43:20
141815/8/2018 2:47:59
14191/9/2018 2:48:18
14201/10/2018 12:48:34
142110/10/2018 12:48:53
14221/11/2018 12:49:52
142317/12/2018 12:50:09
sunny_talwar

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
Creator III
Creator III
Author

YES! it's correct, works very good.

 

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

 

Greatings!