Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Format to use for no leading zeros in dates
Thanks Mufasa this did answer my question.- western93
- Post #3
- Forum: Oracle: All versions
-
Format to use for no leading zeros in dates
Hi, I am trying to insert new dates into table, but having problems getting the format correct. Currently, I am finding the Max date in the table and adding 1 to the variable inside of a for loop. The dates are incrementing as desired but the format is 02/09/2006. The format that I need is...- western93
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
Sum macro for dynamic range
The first zone value always starts in cell A2 and there is never any blanks in the data. The selected bin counts are totaled in column E for the last bin# nbr for the desired zone/bin. zone bin count sum 0 0 1,938 1 100 185 1 102 186 1 103 105 1 106 77 1 107 70 1 108 207 1 109 145 4 400 11...- western93
- Post #3
- Forum: Microsoft: Office
-
Sum macro for dynamic range
I am trying to find a way to setup a macro to sum a range of selected cells in col c when column a condition is true and column b condition is true. The range of the cells changes each day depending if the bin#(column b) had activity or not. (One day the range for zone4 bins400 may start in E34...- western93
- Thread
- Replies: 5
- Forum: Microsoft: Office
