Search results
19 kwi 2012 · I'm having a problem using VBA to execute a SQL query and copy the results into an Excel worksheet. When the sub excecutes, it only copies rows that are multiples of 256 (so rows 256, 512, 768 etc are the only ones that are filled into Excel).
14 mar 2012 · I need to display the current date on my spreadsheet, and I think the TODAY function does that. I formatted the cell as DATE and applied the function to the cell, but what is displayed is the function text =TODAY () instead of the actual date.
16 lut 2022 · You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Current_date = STR_TO_DATE(@Current_date_var, '%m-%d-%Y') , Start_Date = ST' at line 8. I am getting this error.
28 cze 2021 · I used today's date with format =NOW () and tomorrow's date as =NOW ()+1. The query is not pulling up the date from cell reference despite the set parameters, instead it's just using present date making me assume it's not using the parameters. However it is pulling the HOURs and MINUTES correctly.
12 gru 2016 · Recently, I've noticed that on a number of occasions, when I select the output data in the T-SQL "results" tab, right-click, copy, and then right click and paste it into Excel, the output doesn't paste properly.
17 wrz 2018 · IF or any other functions won't help either because there's no function that stores the time it was first called and always returns that value. If you need to insert the current date without changing then you shouldn't use a function, instead insert it statically with Ctrl+; (semicolon).
15 lip 2020 · an excel worksheet has suddenly started showing # signs instead of actual numbers. i've been doing this spreadsheet for over a year without a problem. how can i fix it?
