Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
In that case qlikview assign format as per you define in
SET DateFormat
variable.
Regards
try to create
Month(StartDate) as Month
Day(StartDate) as Day
year(startdate) as year
and load sample data.
Hi,
easiest way,consult database team.
Where you get this format in qlikview or in database??
Also Provide few extra data.
Kind Regards
Hi,
Please find my Attached file.
Hi
I'm New To Qlikview, I'm Learning now.
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
Hi,
In excel it is in MM/DD/YYYY format.
Regards
Hi Avinash,
Please find my Above Attached File.
Regards,
Mahesh.
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
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