Label problem

[Anonymous]

This label doesn't

'Reference : ' + Reference_No + '\nfeature name : ' + Feature_Name + '\nCall
: '+ Call_Dt

The database is SQL and Call_Dt is a Date field

What shoul I write to transform Call_Dt into text in the label

thank you

[Anonymous]

Sql Server supports a Cast() function for this purpose. To convert date to
text (varchar) the syntax would be:
'\nCall: ' + Cast(Call_Dt as varchar).

if that Reference_No field you are using is numeric you will have to cast
that as well.



"Martin Rodrigue" wrote in message
news:9614410F13FDA7691151750A7D016F25@in.WebX.maYIadrTaRb...
> This label doesn't
>
> 'Reference : ' + Reference_No + '\nfeature name : ' + Feature_Name +
'\nCall
> : '+ Call_Dt
>
> The database is SQL and Call_Dt is a Date field
>
> What shoul I write to transform Call_Dt into text in the label
>
> thank you
>
>
>
>
>