1 Reply Latest reply: Nov 27, 2013 9:54 AM by Nicole Smith RSS

    How to conver the normal date formate to isoweek?

      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.

       

      1. Help me out to convert the date into isoweek format.
      2. How to create data source to load the data from .xlsx file?
      3. I am using the Microsoft Office Excel 2007 version. Do we need add any other driver to create the data source?
      4. How do we use the script to query the excl data?

       

      Thanks,