VB.Net - Datediff with SQL Field

Question

I'm trying to do a Datediff in VB.Net thats confusing me.

Basically I'm trying to do the following.

If DateDiff("D", Today(), rsData("Start")) > 0 Then

This is working fine when comparing the value from SQL with todays date. I however need to convert this to check the current month and if it matches then return whatever I'm trying to show below.

The SQL field format is as follows - 2012-01-03 00:00:00.0000000

Thanks!

If the SQL column is, correctly, storing the date as a date or datetime, then it doesn't have a format. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Jan 3, 2012 at 13:02
You want to check if it's the same month? Have you tried DateDiff with DateInterval.Month? I'm not sure if this is a SQL or a VB.NET question. And what is that Today-function? Normally you would use Date.Now to get current datetime. — Tim Schmelter
– Tim Schmelter, Commented Jan 3, 2012 at 13:04
The Today function is a property that just shows todays date - identical I believe to date.now. — PipBoy
– PipBoy, Commented Jan 3, 2012 at 13:33

Uwe Keim · Accepted Answer · 2012-01-03 14:20:01Z

2

'Is the data's month equal to today's month?
If Today.Month = CDate(rsData("Start")).Month Then

End If

edited Jan 3, 2012 at 14:20

Uwe Keim

40.9k61 gold badges193 silver badges309 bronze badges

answered Jan 3, 2012 at 14:18

NoAlias

9,2032 gold badges30 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

NoAlias Over a year ago

Good to hear. It would be appreciated if you could accept this as the correct answer.

Collectives™ on Stack Overflow

VB.Net - Datediff with SQL Field

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related