topic Re: Date Format in QlikView

Date Format

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have Two Columns like StartDate, EndDate in this fields date format like this

StartDate EndDate

1/1/2016, 12/1/2016

how can i Identify which one is "Date and which one is Month".

Regards,

Mahesh.

Re: Date Format

Chanty4u — Fri, 13 May 2016 05:29:31 GMT

try to create

Month(StartDate) as Month

Day(StartDate) as Day

year(startdate) as year

and load sample data.

Re: Date Format

PrashantSangle — Fri, 13 May 2016 05:32:34 GMT

Hi,

easiest way,consult database team.

Where you get this format in qlikview or in database??

Also Provide few extra data.

Kind Regards

Re: Date Format

qlikview979 — Fri, 13 May 2016 05:35:18 GMT

Hi,

Please find my Attached file.

Re: Date Format

qlikview979 — Fri, 13 May 2016 05:36:22 GMT

I'm New To Qlikview, I'm Learning now.

Re: Date Format

avinashelite — Fri, 13 May 2016 05:36:31 GMT

If the data is in date format then use the

month(StartDate) will give month

day(StartDate) will give day but if the data is not in date format then definitely you need to contact your database team

Re: Date Format

PrashantSangle — Fri, 13 May 2016 05:37:50 GMT

Hi,

In excel it is in MM/DD/YYYY format.

Regards

Re: Date Format

qlikview979 — Fri, 13 May 2016 05:40:52 GMT

Hi Avinash,

Please find my Above Attached File.

Regards,

Mahesh.

Re: Date Format

Kushal_Chawda — Fri, 13 May 2016 05:41:20 GMT

If you go to excel file. right click on cell -> Format cells -> You will see the format of date is "DD/MM/YYYY"

so startdate here is 1-Jan-2016 and EndDate is 12-Jan-2016

Re: Date Format

PrashantSangle — Fri, 13 May 2016 05:46:14 GMT

Interesting,

I am getting MM/DD/YYYY format.

Well one more way load it in qlikview convert it into num using num()

check what value you are getting???

Regards

Re: Date Format

avinashelite — Fri, 13 May 2016 05:46:56 GMT

As per the sample data the date format is MM-DD-YYYY

try the month () and day() function you will get the right output

Re: Date Format

Kushal_Chawda — Fri, 13 May 2016 05:48:22 GMT

Do the right click on cell value instead of column header

Re: Date Format

qlikview979 — Fri, 13 May 2016 05:50:48 GMT

Hi Kushal,

I Want to Identify the format in Qlikview only.

imaging if i take in inline how can i identify in that format.

Regards,

Mahesh.

Re: Date Format

PrashantSangle — Fri, 13 May 2016 05:59:55 GMT

Still showing same....

What value you get after loading it in qlikview???

Regards

Re: Date Format

PrashantSangle — Fri, 13 May 2016 06:03:21 GMT

Hi,

In that case qlikview assign format as per you define in

SET DateFormat

variable.

Regards

Re: Date Format

qlikview979 — Fri, 13 May 2016 06:16:09 GMT

Hi All,

I Think, Qlikview will take Standard Format like Variable

SET DateFormat='M/D/YYYY';

Regards,

Mahesh.

Re: Date Format

PrashantSangle — Fri, 13 May 2016 06:18:01 GMT

Yes.

Regards

Re: Date Format

qlikview979 — Fri, 13 May 2016 06:23:22 GMT

Hi,

Thanks to all for your Support.

Regards,

Mahesh.

Re: Date Format

qlikview979 — Fri, 13 May 2016 06:27:55 GMT

Hi,

Thanks Avinash.

Regards,

Mahesh