|
 |
access_asp thread: date from 3 pop menus
Message #1 by jake williamson 28 <jake.williamson@2...> on Fri, 19 Apr 2002 17:26:10 +0100
|
|
mon chums! have a poser for yous...
i got three pop ups, one with days, one with months and one with years. so:
mnuDay mnuMonth mnuYear
and i want to join them to reflect:
26/06/1975
in my database (assuming that the person has the same birthday as me!)
thing ism how do i join these up to make one date in my database?? my
thinking is some smart piece of code that says:
get value 'mnuDay' / get value 'mnuMonth' / get value 'mnuYear'
but how do i join it up???????
any ideas oh gurus???
cheers and have good weekends,
laters,
jake
Message #2 by Abdul Sami <abdul_sami_20@y...> on Fri, 19 Apr 2002 12:13:22 -0700 (PDT)
|
|
You can use & sign to join the three values:
thedate=datevarialble & "/" & monthvarialble & "/" & yearvarialble
--- jake williamson 28 <jake.williamson@2...> wrote:
>
>
> mon chums! have a poser for yous...
>
> i got three pop ups, one with days, one with months and one with years.
> so:
>
> mnuDay mnuMonth mnuYear
>
> and i want to join them to reflect:
>
> 26/06/1975
>
> in my database (assuming that the person has the same birthday as me!)
>
> thing ism how do i join these up to make one date in my database?? my
> thinking is some smart piece of code that says:
>
> get value 'mnuDay' / get value 'mnuMonth' / get value 'mnuYear'
>
> but how do i join it up???????
>
> any ideas oh gurus???
>
> cheers and have good weekends,
>
> laters,
>
> jake
>
>
=====
Abdul Sami
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
Message #3 by jake williamson 28 <jake.williamson@2...> on Sat, 20 Apr 2002 14:27:14 +0100
|
|
hi abdul,
thanks both for getting back to me, makes sense!
thing is, where do i put it in the page?? in the SQL or as a hidden form
field??
i've tried both and still no joy...
any pointers would be grand (its set up with the form and the insert record
on the same page rather than sending varibles to the next page for
inserting)
many thanks,
jake
on 19/4/02 20:13, Abdul Sami at abdul_sami_20@y... wrote:
> You can use & sign to join the three values:
>
> thedate=datevarialble & "/" & monthvarialble & "/" & yearvarialble
>
>
> --- jake williamson 28 <jake.williamson@2...> wrote:
>>
>>
>> mon chums! have a poser for yous...
>>
>> i got three pop ups, one with days, one with months and one with years.
>> so:
>>
>> mnuDay mnuMonth mnuYear
>>
>> and i want to join them to reflect:
>>
>> 26/06/1975
>>
>> in my database (assuming that the person has the same birthday as me!)
>>
>> thing ism how do i join these up to make one date in my database?? my
>> thinking is some smart piece of code that says:
>>
>> get value 'mnuDay' / get value 'mnuMonth' / get value 'mnuYear'
>>
>> but how do i join it up???????
>>
>> any ideas oh gurus???
>>
>> cheers and have good weekends,
>>
>> laters,
>>
>> jake
|
|
 |