I have requirement to get data between previous month first day and last day.
Below is the code i am using to get last day of previous month but not knowing how to get first day of last month. I have some info on Month.First(server edition) but i need in parallel . Any suggestions?
Getting the last day of a month is the tricky part, getting the first day should be simple since it is always '1' so hard-code it in your transformation much like you are already doing.
-craig
"You can never have too many knives" -- Logan Nine Fingers
I understood what you are looking for, I do believe, at least in the original post. I was responding to your specific statement that you are "not knowing how to get first day of last month". You were already getting the "last month" according to what you posted so was just trying to point out that figuring out what the first day of that was is pretty darn straight-forward.
So... what exact help are you looking for here? It looks like you've just expanded the scope of your question, hence my question.
-craig
"You can never have too many knives" -- Logan Nine Fingers
You've got to be really careful of using this. It won't always give you what you expect unless you set your expectations in line with how it really works .Just remembered this discussion viewtopic.php?t=149999
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
I've been wary of this function ever since. Always try finding alternates, albeit longer and more cumbersome. There ought to be a more elaborate documentation replete with examples to explain the modus operandi of this function.
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
I think my research conclusions in the other thread suffice as documentation of the modus operandi, as you put it. This is How It Works, even though it's not what you want it to do.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.