Discussion Board for collaboration related to QlikView App Development.
I have Two Columns like StartDate, EndDate in this fields date format like this
how can i Identify which one is "Date and which one is Month".
easiest way,consult database team.
Where you get this format in qlikview or in database??
Also Provide few extra data.
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
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
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???