can you give an example of the CAST? Usha A Dewasthali 7.Jul.15 08:42 PM a Web browser LEI LEI - 6.0Windows 2000
Hi Thomas,
Would you mind giving me an example of the CAST used in a SELECT statement?
I am having a similar issue going from Notes to Notes. I have a notes/date time field, but in a legacy database it used to be set as a TEXT field. The fields have the same name, but in any documents where the field is set to a TEXT field, it will simply leave it blank on my new database when it does the direct transfer. I have tried a number of different @texttotime dt formulas on the target connection doc, but nothing seems to work. any help would be appreciated if you got this to work either in a DT or replication. Thanks!