Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
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
];

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