"Use case regarding functions"

Question

Hi, 
 I have a doubt in using text() function and datetext() function, as i already gone through the documentation suggesting that both are quite similar only difference is their syntax. 
 my doubt is, at which scenario's we can go for these functions. Can anyone of you make me understand with some live scenarios.

Thanks & Regards, 
 KDR

sandeepd · Answer

Hi @Dharma, If you can look into the description of both the functions. In text() function we can type cast Converts number, date, time, or datetime timestamp into string or any specific format like this : text(2,"$0.0"), but it is not possible in datetext(). datetext() : Interprets the date or datetime specified in the user preferred calendar and returns its string representation using given format. Thanks, Sandeep

yeswanththiyarir · Answer

Hi, 
Text takes many types of inputs but datetext needs a date as input.As the name suggests datetext is for dates and text can be used for other types also. 
Thanks, 
Yeswanth.