Parshing Strings (dates) 1

[Guest_imported]

Hi,I have a problem...I had a textfield where dispaled dates from an SQL db. I want to replace it with 3 drop down menus, but when the page will be loaded, I would like the drop down menus to display the dates as before, but each drop down menu will display the day, the month and the year seperatelly. Can you help me with the code for parshing the string(dates) and put it in variables
dd &"/" & mm & "/" & yyyy in order to have the willing resaults?

 

[RobSchultz]

Use the DatePart function:

myDate = date from SQL record

dd = DatePart("d", myDate)
mm = DatePart("m", myDate)
yyyy = DatePart("yyyy", myDate)

returnDate = dd & "/" & mm & "/" & yyyy

Later, Rob
robschultz@yahoo.com
-Focus on the solution to the problem, not the obstacles in the way.-