Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have in date in Excel like
STARTDATE ENDDATE
27/03/2016 31/05/2016
I need output like
Hi Digvijay,
Exactly Output. .thanks for your support.
Here 'Chr(13) 'what will represent and if i add the july month in End date i am getting like this
"April,May,June" Why march Month is not coming.
Regards,
Mahesh
Mahesh,
There is no Use of that Chr()
Expression :
=Date(Date#(StartDate,'DD/MM/YYYY'),'YYYY_MMM') &
Date(Addmonths(Date#(StartDate,'DD/MM/YYYY'),1),'YYYY_MMM') &
Date(Date#(EndDate,'DD/MM/YYYY'),'YYYY_MMM')
Note: Close this Thread ASAP if Correct??
Hi,
Here one more Doubt I am loading data from" Excel this code is not working".
Regards,
Mahesh
Hi Anil,
I am loading data from excel file "Digvijay Singh" Code is not working.
Why, It should work.
QlikView is Case Sensitive. Please try to edit the field names....
Working
Check this
Hi Mahesh,
The data I added manually, you can load it from Excel, but what I did will work for the data you shared, let me think of making it dynamic. I just shared to get more details
Hi Anil,
Please check once if i add the June month in excel .i am not getting "March,April,May, June" This 4 months.
I am getting only Three months ? why one month is missing ?
Hi Digvijay,
Please find the attached file.
Sorry now your code is working, But here i Have one doubt If i change in my source "May
Instead of "june " i am getting only Three months .
Here I want Mar,Apr,May,June. if i add more one more month also I want that month name also.
Regards,
Mahesh.
Hi Manuel Capella,
When i go for reload I'm got getting any thing data.
Regards,
Mahesh,