I have many tables among which i have data by name transaction date in a folder which has 6 months of data (that is there are again 6 folders from Jan to jun ) and each folder has 30 excel sheets for that particular month iam attaching the screen shot so that u can understand it clearly and the date formate is like 02-12-2014.
What i want to know is how do i fetch all 30 exzcel sheets at a time and convert the dtae formate as Jan-02-2014 for all the months and days .
You can use the date() function to change the format of a date: date(MyDateField, 'MMM-DD-YYYY') will format dates like you want. If your date field contains text values instead of date values you first have to use the date#() function to change the text value into a date value. For example date(date#('02-12-2014','DD-MM-YYYY'),'MMM-DD-YYYY')