trim

[iuphim]

hi i would like to trim for just the day in a date, please help write this.

if 5/25/2010 - i want the "25" part only.

Thanks,

 

[jdraw]

hi i would like to trim for just the day in a date, please help write this.

if 5/25/2010 - i want the "25" part only.

Thanks,

You could just use a format statement on the date involved and select only the "Day" portion of date

eg.

format (#5/25/2010#,"dd")

 

[rainman89]

try format([yourdatefield], "d")

 

[Mr. B]

Try using the DatePart function.

the code below will return the day of the current date.

Dim varDay
varDay = DatePart("d", Date)

or to use your field:

Dim varDay
varDay = DatePart("d", YourDateFieldHere)

 

[iuphim]

Thank you all for the prompt reply. This is a great help!!