topic Re: find date in QlikView

find date

inam — Thu, 20 Apr 2023 11:29:30 GMT

hello community

I have column date created I want only date .

some rows has date with time & some row only date..i need only date .

for example:-

input:-

Date Created

13-12-2021

15-07-2022

15-06-2022 11:52

17-03-2023 17:52

output

Date

Re: find date

Kushal_Chawda — Thu, 20 Apr 2023 11:35:23 GMT

@inam try below

=date(floor([Date Created])) as Date

day(floor([Date Created])) as Date

Re: find date

inam — Thu, 20 Apr 2023 12:05:04 GMT

if i use =date(floor([Date Created])) as Date

output is 13-12-2021

and if i use day(floor([Date Created])) as Date

output is only 13 is correct but date with time output is not show

Re: find date

Kushal_Chawda — Thu, 20 Apr 2023 14:53:22 GMT

@inam seems like your Date with time is not in Date and Time Format.. first try to format it

in your load script.. change the date and timestamp format as per the input data format.

SET DateFormat='DD-MM-YYYY';
SET TimestampFormat='DD-MM-YYYY hh:mm';

Re: find date

MarcoWedel — Fri, 21 Apr 2023 18:02:55 GMT

If it's really only the day part of those dates and timestamps you're interested in, maybe just

Left([Date Created],2)

would suffice?

table1: LOAD Left([Date Created],2) as Date FROM [https://community.qlik.com/t5/QlikView-App-Dev/find-date/td-p/2062522] (html, codepage is 1252, embedded labels, table is @1);