DTOS()
is easier to read thanDTOC(,1)To Preserve consistency, what I would do is create the following function
Function TTOS(tdDate) >Return TTOC(tcDate,1)This way, there would be a matching TTOS and DTOS function, with both being easy to read, and not requiring the ,1 parameter, which is in no way self documenting.
Both structures would certainly work, but given a choice, I would choose the self documenting form over a parameter that I would have to look up when I see it. You may be able to remember all of these parameters offhand, but I, unfortunately, cannot.
>
I don't see a problem in using either of them. I would stay away from TTOS() UDF or any other in the index keys because cure would be worse than decease.