Prev: EMKAi- looking for a Graphic Designer/Brand Manager
Next: Error message on Treeview
From: Vic33 on 12 May 2010 15:57
Ahhh...the simple explanation goes a long way. Thanks! I should be in 'new
user' forum I realise now. All sorted, much appreciated.
Regds
Vic

"Rick Brandt" wrote:

> Vic33 wrote:
>
> > Phew, you assume that I know what I'm doing! Can't I just use the
> > dateserial
> > function? I've tried this: set [datefield] =
> > dateserial([day],[mo],[yr]);
> > to no avail. My three fields are txt fields, not numeric. I'm doing
> > something basic wrong but not sure what.
>
> DateSerial's arguments go Year, Month, Day. You have them backwards.
>
> Allen's code was simply trying to make sure that three entries are strings
> that represent numeric values. If someone were to enter alpha-characters
> DateSerial would raise an error.
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: EMKAi- looking for a Graphic Designer/Brand Manager
Next: Error message on Treeview