Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks,
1. See the load script in the attached .qvw (File > Edit Script)
2. We don't need to create a data source. We can load directly from the .xlsx file (see the load script in the attached .qvw--File > Edit Script)
3. No
4. See the load script in the attached .qvw (File > Edit Script)