DATE question

[sabavno]

Hi,

How to break date into the three variables?

Example:

datDate = 10/01/01

I want

datMonth = 10
datYear = 2001
datDay = 01

THanks.

 

[mp9]

datMonth = Month(datDate)
datYear = Year(datDate)
datMonth = Day(datDate)

HTH

http://www22.brinkster.com/accessory/

 

[PaulBricker]

Well you can try this.

datMonth = Month(DateField)
datYear = Year(DateField)
datDay = Day(DateField)

That should give you want you want.

Paul

 

[mbiro]

Dim x As Date

x = #10/21/2002#

Me.Text0.Value = DatePart("m", x)
Me.Text2.Value = DatePart("d", x)
Me.Text4.Value = DatePart("yyyy", x)