ComboBox filled with Data Type Date/Time in Format dd.MM.yyyy

forum.td.development (2005-2010)
Jens Balk

ComboBox filled with Data Type Date/Time in Format dd.MM.yyyy

Post by Jens Balk » 16 Mar 2005, 10:44

 Posted by:  Jens Balk 

Hi,

how can I fill a ComboBox with the Data Type Date/Time and in the Format
dd.MM.yyyy?

Call SalListPopulate( cmb1, hSql, 'SELECT DATE1 FROM TBL_DATE ')

has follow Result: 2004-02-01-00.00.00
but I need: 01.02.2004 (without the Time and in Format dd.MM.yyyy)

any Ideas?

regards

-Jens

Heinz Steinmann

ComboBox filled with Data Type Date/Time in Format dd.MM.yyyy

Post by Heinz Steinmann » 16 Mar 2005, 11:19

 Posted by:  Heinz Steinmann 

Hi Jens,

try this :

Call SalListPopulate( cmbBonusStufenDatum, w_hSqlWork,
'Select @DATETOCHAR( datefieldname, \''||FORM_DATE||'\')
from
sysadm.tablename')

FORM_DATE = String: FORM_DATE = 'dd.MM.yyyy'

--
Best regards

Heinz Steinmann

GARANT-MÖBEL Service GmbH & Co. KG
Hauptstr. 143, D-33378 Rheda-Wiedenbrück, Germany
http://www.garant-moebel-gruppe.de
Tel.: +49 5242 409-143 Fax: +49 5242 409388

Jens Balk

ComboBox filled with Data Type Date/Time in Format dd.MM.yyyy

Post by Jens Balk » 16 Mar 2005, 12:00

 Posted by:  Jens Balk 

thanks

Hernán Canales

ComboBox filled with Data Type Date/Time in Format dd.MM.yyyy

Post by Hernán Canales » 16 Mar 2005, 20:53

 Posted by:  Hernán Canales \(From Chile\) 

Hi Jens.

I thinks you should generate Result set with date and use
SalListAdd(hWndItem, SalFormat..()) function.

Hernán

Return to “td.development”

Who is online

Users browsing this forum: [Ccbot] and 0 guests