Hi
New to the forum, and was recommended by another user bklabel1.
New to the forum, and was recommended by another user bklabel1.
I have created a large extract using query builder and post processing within HP ALM 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.
Regards
Sean
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.
Regards
Sean