HP ALM 12.00 - Query Builder / Post Processing Current Date Extract
I have created a large extract using query builder and post processing which extracts data in various guises to a number of excel worksheets. I have now been asked if I can add the current date in a specified format to one of the name tabs in the workbook.
I am struggling to find out how to extract the date, and then be able to format it onto the name tab akin to Sheets("Query1").Name = CURDATE(), the CURDATE being the element that I don't know what I can use within the SQL extract.
Any assistance please, believe that the date may have to be selected in a specific format and then manipulated, but not sure of the correct syntax.
I hope that it is OK to recommend another site named MrExcel.com for Excel questions. In the past I have been posting on both sites with a mention on each site that I am asking the question in two places.
This site often gives great advice on automation tools and often Excel tips as well. When it is purely Excel I usually go to the Excel site as well. And it is no harm to place the answer back on your original questions on this board.
I hope this advice is not breaking any rule. If so a moderator will let me know.