Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Phara
Contributor III
Contributor III

Formula : Add a word

Hello,

 

I have a formula that is calculating the number of days between today and the date. I would like to add the word ''days'' after the number, for an example ''20 days'' My actual formula is =today()-[Cration Date](Days)

 

 

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

=Dual(today()-[Cration Date]&' Days',today()-[Cration Date]) 

Or 

=Interval(today()-[Cration Date],'d Days')

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

=Dual(today()-[Cration Date]&' Days',today()-[Cration Date]) 

Or 

=Interval(today()-[Cration Date],'d Days')

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Vegar
MVP
MVP

You could format it to a number with format as below. 

= num(today()-[Cration Date], '# ##0 days')