Date Format

[qlikview979]

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.

[Chanty4u]

try to create

Month(StartDate) as Month

Day(StartDate) as Day

year(startdate) as year 

and load sample data.

[PrashantSangle]

Hi,

easiest way,consult database team.

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

Also Provide few extra data.

Kind Regards

[qlikview979]

Hi,

Please find my Attached file.

[qlikview979]

Hi

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

[avinashelite]

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

[PrashantSangle]

Hi,

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

Regards

[qlikview979]

Hi Avinash,

Please find my Above Attached File.

Regards,

Mahesh.

[Kushal_Chawda]

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

[PrashantSangle]

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