Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rt_new_user
New Contributor II

How to strip my date field which is in this format (DD/MM/YYYY hh-mm-ss AM/PM) into something like this (DD/MM/YYYY) and basically get rid of the time part?

Screen Shot 10-28-15 at 11.57 AM.JPG

1 Solution

Accepted Solutions
oknotsen
Honored Contributor III

Re: How to strip my date field which is in this format (DD/MM/YYYY hh-mm-ss AM/PM) into something like this (DD/MM/YYYY) and basically get rid of the time part?

Floor it.

When loading the timestamp, use the floor() function to remove the time part.

Floor(someDate) as someDate,

If it still shows with the time as part of it, add the date() function.

May you live in interesting times!
2 Replies
oknotsen
Honored Contributor III

Re: How to strip my date field which is in this format (DD/MM/YYYY hh-mm-ss AM/PM) into something like this (DD/MM/YYYY) and basically get rid of the time part?

Floor it.

When loading the timestamp, use the floor() function to remove the time part.

Floor(someDate) as someDate,

If it still shows with the time as part of it, add the date() function.

May you live in interesting times!
rt_new_user
New Contributor II

Re: How to strip my date field which is in this format (DD/MM/YYYY hh-mm-ss AM/PM) into something like this (DD/MM/YYYY) and basically get rid of the time part?

Thanks it worked!!

Community Browser