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
Discussion posts and replies are publicly visible
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