davegoodo's latest activity
-
Ddavegoodo replied to the thread Solved DatePart function error.Thanks, I did do some doubling up on the work, but it all worked out really well.
-
Ddavegoodo replied to the thread Solved DatePart function error.Thanks Gasman! Believe or not I am using it that way. I decided to focus on the Excel side and the best way of displaying these...
-
Ddavegoodo replied to the thread Solved DatePart function error.Thanks for the response. I wouldn't mind if you wrote some code, it would be helpful. I have been doing some tinkering with Excel VBA...
-
Ddavegoodo replied to the thread Solved DatePart function error.Thank you. I appreciate you are trying to help me. I'm going to experiment with taking the number e.g. 202403 and see if I can tinker...
-
Ddavegoodo replied to the thread Solved DatePart function error.Hi, when I run that in the Immediate window I get 24-Apr-2024. Maybe something could be done with VBA? When you say it's arbitrary I'm...
-
Ddavegoodo replied to the thread Solved DatePart function error.Having had 24 hours to consider the expression, I wonder if it is possible to reverse engineer the number into a date type. e.g. 202404...
-
Ddavegoodo replied to the thread Solved DatePart function error.I forgot to mention your 10000 * year formula which creates 4 placeholders. You've certainly turned my head on this ideas. Very...
-
Ddavegoodo replied to the thread Solved DatePart function error.Thanks, I just replied to @Gasman and said what a good idea this is. Using year * 100 to create 2 placeholders for the months to slot...
-
Ddavegoodo replied to the thread Solved DatePart function error.Thank you. I see what is happening now, the year * 100 creates 2 placeholders for months to slot in. Very good. Thanks for...
-
Ddavegoodo replied to the thread Solved DatePart function error.What I would like to know is why multiplying by 100 works? The result is great, I've been able to apply this to my queries and they are...
-
Ddavegoodo replied to the thread Arrange Immediate, Local, Watch windows.Thanks for your reply. I leave the immediate window open all the time, and the others I open as needed.
-
Ddavegoodo replied to the thread Solved DatePart function error.My apologies. I've just run the SQL and it does exactly what I'm wanting. I was asleep at the wheel. Didn't think it through. That's...
-
Ddavegoodo replied to the thread Solved DatePart function error.OK, I get it, its VBA, I just ran it in the Immediate window and it gives 202404. Very good! So this is some way I can organise my...
-
Ddavegoodo replied to the thread Solved DatePart function error.Pardon my ignorance but where do I run it? Is it SQL or VBA? I just tried SQL but it wants an Update or Select or something, I give up...
-
Ddavegoodo replied to the thread Solved DatePart function error.That's fantastic! It's something I can use to group my data further. That's food for thought and application. I shall study that...