How would I combine these to make my date field look like this 20090531
select year(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1,0)))
select month(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1,0)))
select day(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate() )+1,0)))
I have an Enter_RMA form with a cmd btn on it. The btn opens another form. I would like to have the Customer_ID and Order_ID from the Enter_RMA form be on the just opened frm_6 form. I've been looking all over the place and can't seem to figure it out. Any help would be much appreciated. Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.