Expression Help

[abhaysingh]

i have posting date in DD/MM/YYYY format and one field No of days in days format like 20 days, 30 days

i want to add Posting Date + No of Days

what would be expression?

[abhaysingh]

what is DAYSdays...

[its_anandrjs]

Hi Abhay,

In the fields you have data 20 days, 30 day so for getting 20,30... we have to remove day string from field for this i use Purgechar to remove day, days or DAYS if this string in the field then this string removes from the field and you get 20,30....

You can try

Date( Date(Date#([Posting Date],'DD/MM/YYYY')) + Purgechar( [No of Days], 'days') )

Regards,

Anand

[alkesh_sharma]

Purgechar function removes the characters from the field value.

For eg: purgechar(abc123,'123') output is abc, therefore the characters 123 has been purged/removed