Hi This is a stored procedure I use but you can use the syntax in a Direct to DataBase action
UPDATE physio.re400 SET re400datetosecs = DATEDIFF([second], '1970/01/01 00:00', re400startdate) FROM physio.v_patient_info_noRE150 v1,physio.re400 WHERE (v1.id_pa100 = physio.re400.id_pa100authztn) AND (v1.id_de300orgdep=@@de300) AND (id_pa100authztn = @@pa100) -- If you try to make dateToSecs COMPUTED column it will fail -- Unable to modify table. --Computed column 're400datetosecs' in table 'Tmp_re400' --is not allowed to be used in another computed-column definition. -----Original Message----- From: Tom Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2008 1:18 PM To: witango-talk@witango.com Subject: Witango-Talk: User defined SQL function Does anyone have/use a UDF for MS SQL that works similarly to the <@datetosecs> Witango metatag? I'm not smart enough to write one. LOL! TIA Tom Ferguson ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf