Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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


  Return to Index