CODEWITHSUNDEEP
asp.netvb.netdatediff
PipBoy
PipBoy

Reputation: 1137

VB.Net - Datediff with SQL Field

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!

Upvotes: 2

Views: 731

Answers (1)

NoAlias
NoAlias

Reputation: 9193

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

End If

Upvotes: 2

Related Questions