Using a variable in Date data type

Question

Currently I am looking at retrieving payments from a OLEDB Database, using quarters of the financial year.

The retrieval of the quarters works, but the part which doesnt is the year part. As shown below

Public Q1 As Date = Date.FromOADate(31 / 3 / 2014)
Public Q2 As Date = Date.FromOADate(30 / 6 / 2014)
Public Q3 As Date = Date.FromOADate(30 / 9 / 2014)
Public Q4 As Date = Date.FromOADate(31 / 12 / 2014)

Is what I currently use, but I would much rather the year to be a variable which can be retrieved from a combobox selection. Like so

Public Q1 As Date = Date.FromOADate(31 / 3 / Yearcombox.Text)
Public Q2 As Date = Date.FromOADate(30 / 6 / Yearcombox.Text)
Public Q3 As Date = Date.FromOADate(30 / 9 / Yearcombox.Text)
Public Q4 As Date = Date.FromOADate(31 / 12 / Yearcombox.Text)

Yet this does not work because of the data type 'Date' and presents a error which doesn't allow the form to load.

Is there a way to do this?

FromOADate requires a double type as per MSDN

Usman Waheed
– Usman Waheed

2014-01-30 10:10:05 +00:00
Commented Jan 30, 2014 at 10:10 — Usman Waheed
– Usman Waheed, Commented Jan 30, 2014 at 10:10

pankeel · Accepted Answer · 2014-01-30 11:44:44Z

2

write This Way To Find Out The Date

you can convert the year to Double.

Follow This Code TOmSolve Your Problem.

Date.FromOADate(30 / 3 / CDbl(Yearcombox.Text))

edited Jan 30, 2014 at 11:44

answered Jan 30, 2014 at 10:47

pankeel

1,1331 gold badge10 silver badges22 bronze badges

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

1 Comment

OcelotcR Over a year ago

Thank you, I was not aware of this!

Collectives™ on Stack Overflow

Using a variable in Date data type

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