ansaurus

Question

Answer 1

A:

Something like:

Dim dateString as String = string.format("{0:yyyy-MM-dd}", New DateTime(DateTime.Now.Year,DateTime.Now.Month, 1))

ozczecho 2009-08-27 05:06:46

Those 'm's need to be capitalized; lower case will give you minutes.

Dan Tao 2009-08-27 05:16:19

hahaha...yes ofcourse :-)

ozczecho 2009-08-27 05:17:46

Answer 2

+3 A:

It looks like you want two strings representing the first and last days of the current month. In that case you can do the following:

Dim today As Date = Date.Today
Dim desiredFormat As String = "yyyy-MM-dd"

Dim fromDate As Date = New Date(today.Year, today.Month, 1)
Dim dteFrom As String = fromDate.ToString(desiredFormat)

Dim toDate As Date = fromDate.AddDays(Date.DaysInMonth(today.Year, today.Month) - 1)
Dim dteTo As String = toDate.ToString(desiredFormat)

Dan Tao 2009-08-27 05:11:42

Answer 3

+1 A:

This will be the closest to your original code:

dteFrom = Format(CDate(Year(Date.Today) & "-" & Month(Date.Today) & "-" & "01"), "yyyy-MM-dd")
dteTo = Format(CDate(Year(Date.Today) & "-" & Month(Date.Today) & "-" & Date.DaysInMonth(Year(Date.Today), Month(Date.Today))), "yyyy-MM-dd")

This will be a more ".NET" way to do it :

dteFrom = String.Format("{0:yyyy-MM}-01", Date.Today)
dteTo = String.Format("{0:yyyy-MM}-{1:00}", Date.Today, Date.DaysInMonth(Year(Date.Today), Month(Date.Today)) )

awe 2009-08-27 06:37:23

Note that the format string is uppercase **M** for month. Lowercase **m** is minutes. The VB6 function was "smart" and distinguished between minutes and month based on the logic in the pattern (looks like a date - month, looks like a time - minutes). In .NET you have to distinguish between upper and lowercase, just as for the String.Format function.

awe 2009-08-28 05:53:49

ansaurus

tags:

views:

answers:

How to write a Date Code In vb.net?

related questions