DateAdd(dd, - day(getdate()),getdate()) to VB.net

Question

User-458875980 posted

SQL - DateAdd(dd, - day(getdate()),getdate())

need to convert this into VB.net

 

Thanks,

Rajesh G

Answer 1

User1935975665 posted

Not sure I understood the sql statement but if you're trying to get last day of the previous month I think this works.

DateAndTime.DateAdd(DateInterval.Day, -DateAndTime.Today.Day, Today)

Answer 2

User551462331 posted

try this

using  Microsoft.VisualBasic

DateTime dtNew = DateAdd(DateInterval.Day, DateTime.Now.Day-(DateTime.Now.Day*2), DateTime.Now);

hope this helps...

Answer 3

User533502567 posted

SQL - DateAdd(dd, - day(getdate()),getdate())

Like this..

            DateTime dt = DateTime.Now;
            dt = dt.AddDays(-(dt.Day));