Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Date Format

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.

1 Solution

Accepted Solutions
PrashantSangle

Hi,

In that case qlikview assign format as per you define in

SET DateFormat

variable.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

18 Replies
Chanty4u
Champion III
Champion III

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

Great dreamer's dreams never fulfilled, they are always transcended.
qlikview979
Specialist
Specialist
Author

Hi,

Please find my Attached file.

qlikview979
Specialist
Specialist
Author

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

Great dreamer's dreams never fulfilled, they are always transcended.
qlikview979
Specialist
Specialist
Author

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

Great dreamer's dreams never fulfilled, they are always transcended.