Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
parameter format
Hi Folks,
I have developed a nifty little workbook that opens on a schedule, runs a query against a SQL db, massages the data to remove zero's and add some math functions, creates a clean (no macros) copy and emails it off to sales guys at four in the morning. It works like a charm with the exception of my data parameter... the format in my db is yyyy-mm-dd. I have a cell in my workbook which is = TODAY() and I can create a custom format for the cell as yyyy-mm-dd but it doesn't seem to work when I run the file. I'm not sure where to start troublshooting this so any suggestions would be greatly appreciated. TIA! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parameter Query Format Issues | Excel Programming | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
Format when sending a range as parameter to a custom function | Excel Programming | |||
format optional parameter | Excel Worksheet Functions | |||
format optional parameter | Excel Discussion (Misc queries) |