• State Suggested Answer
  • Replies 3 replies
  • Answers 2 answers
  • Subscribers 8 subscribers
  • Views 2729 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

"Use case regarding functions"

Dharma

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

Parents
  • 0
    Hi Dharma Rao,

    The datetext() function uses a similar, but slightly different syntax than the text function.
    and apart form that datetext() function can not take the integer value as input to convert into specified date format(ex:datetext(0,"mm/dd/yyyy") leads to error), where as text() can take the integer input value and gives the date (ex: text(0,"mm/dd/yyyy") -->O/P 01/01/2035) . text () function treats 01/01/2035 as base date, for positive value text() function will add the date to base date for negative value it will decrease the date from base date(ex: text(10,"mm/dd/yyyy") -->O/P 01/11/2035, text(-10,"mm/dd/yyyy") -->O/P 12/22/2034).

    Thanks,
    Ravindar G
Reply
  • 0
    Hi Dharma Rao,

    The datetext() function uses a similar, but slightly different syntax than the text function.
    and apart form that datetext() function can not take the integer value as input to convert into specified date format(ex:datetext(0,"mm/dd/yyyy") leads to error), where as text() can take the integer input value and gives the date (ex: text(0,"mm/dd/yyyy") -->O/P 01/01/2035) . text () function treats 01/01/2035 as base date, for positive value text() function will add the date to base date for negative value it will decrease the date from base date(ex: text(10,"mm/dd/yyyy") -->O/P 01/11/2035, text(-10,"mm/dd/yyyy") -->O/P 12/22/2034).

    Thanks,
    Ravindar G
Children
No Data

© 2024 Appian. All rights reserved.