Friends, I have some fields in the .xlsx sheet for example, TicketNo, Status, TicketCreatedDate, and so on. Now the "TicketCreatedDate" is in the format of (4/15/2013 9:36:02 AM). So i nneed get all the date filed form the the sheet and i want to convert this date into its equivalent isoweek.
Help me out to convert the date into isoweek format.
How to create data source to load the data from .xlsx file?
I am using the Microsoft Office Excel 2007 version. Do we need add any other driver to create the data source?