Default Date

[prakashwadhwani]

I'd like the default date in a text box to be 31(dd) + 12(mm) +
2006(current year-1).

The YEAR part of the date should sense that the current year is 2007
and so deduct 1 & set the year as 2006 as indicated above.

So basically the day will always be 31.
The month will always be 12.
The year should be (current year - 1).

How can i accomplish this ?

Rgds,
Prakash.

[ARC]

Try putting this in the "Default Value" property of the text box:
CVDate("31/12/" & Year(Now())-1)


<pr*************@gmail.comwrote in message
news:11*********************@r34g2000hsd.googlegro ups.com...

I'd like the default date in a text box to be 31(dd) + 12(mm) +
2006(current year-1).

The YEAR part of the date should sense that the current year is 2007
and so deduct 1 & set the year as 2006 as indicated above.

So basically the day will always be 31.
The month will always be 12.
The year should be (current year - 1).

How can i accomplish this ?

Rgds,
Prakash.

[Prakash Wadhwani]

Thx! Worked like a charm.

I tried searching the Access & VBA Help for the syntax & further details
on CVDate to no avail.

However I did find a little info on the CDate function though not
enough.

Could you point me to any site that has more info on these with some
examples and if possible explain what is the difference between these 2
functions ?

Best Rgds,
Prakash.
*** Sent via Developersdex http://www.developersdex.com ***

[ARC]

You're welcome. I've never used CDate, and my only source was the access 97
help file, and looking through all the date functions.

I did play with the syntax a bit, and it took a number of tries to get it, I
tried Year(Now() -1), but that errored out.. So you have to take off the 1
after the Year() function, not within it. Definetely trial and error.. After
the inner parens, Access will just see: CVDate("31/12/2006")

"Prakash Wadhwani" <si****@omantel.net.omwrote in message
news:46*********************@news.qwest.net...

Thx! Worked like a charm.

I tried searching the Access & VBA Help for the syntax & further details
on CVDate to no avail.

However I did find a little info on the CDate function though not
enough.

Could you point me to any site that has more info on these with some
examples and if possible explain what is the difference between these 2
functions ?

Best Rgds,
Prakash.
*** Sent via Developersdex http://www.developersdex.com ***

[Arno R]

"ARC" <an**@andyc.comschreef in bericht news:jH*******************@newssvr12.news.prodigy. net...

You're welcome. I've never used CDate, and my only source was the access 97
help file, and looking through all the date functions.

I did play with the syntax a bit, and it took a number of tries to get it, I
tried Year(Now() -1), but that errored out.. So you have to take off the 1
after the Year() function, not within it. Definetely trial and error.. After
the inner parens, Access will just see: CVDate("31/12/2006")

Year(Now() -1) or Year (Now -1) will give you 2007, so it did not result in the right output.
Is this what you mean with 'errored out' ??

Also: Now() gives you the date AND the time.
Better use Date() if you only want to use the date.

Another option for OP's question is the DateSerial() function.
DateSerial(Year(Date) -1, 12, 31)

Arno R

[ARC]

No, what I meant was, if I put the -1 within the Year() parenthesis, I got a
#Error in the text box field (when used in the default value field). When I
moved the -1 out of the Year function, it worked.

You're correct of course, much better to use Date() than Now(). Date Serial
seems like a easier function to deal with.

"Arno R" <ar****************@planet.nlwrote in message
news:46***********************@text.nova.planet.nl ...

"ARC" <an**@andyc.comschreef in bericht
news:jH*******************@newssvr12.news.prodigy. net...

You're welcome. I've never used CDate, and my only source was the access
97
help file, and looking through all the date functions.

I did play with the syntax a bit, and it took a number of tries to get it,
I
tried Year(Now() -1), but that errored out.. So you have to take off the 1
after the Year() function, not within it. Definetely trial and error..
After
the inner parens, Access will just see: CVDate("31/12/2006")

Year(Now() -1) or Year (Now -1) will give you 2007, so it did not result in
the right output.
Is this what you mean with 'errored out' ??

Also: Now() gives you the date AND the time.
Better use Date() if you only want to use the date.

Another option for OP's question is the DateSerial() function.
DateSerial(Year(Date) -1, 12, 31)

Arno R

[Prakash Wadhwani]

Thx Arno !

The Date() function does seem more logical and yes ... DateSerial does
seem a better way of going about it.
LYLE ... thx for the tip on how to dig into the Access help. I tried it
& it seems to work a treat. I'm using Access 2003.

Rgds,
Prakash.
*** Sent via Developersdex http://www.developersdex.com ***