Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
rangesum([Posting Date], keepchar([No of days],'0123454789'))
Try like
[Posting Date] + Purgechar( [No of Days], 'daysDAYS')
or
Date#([Posting Date],'DD/MM/YYYY') + Purgechar( [No of Days], 'daysDAYS')
Regards
Anand
not working pls help,
wat i want is
if( (postingdate + No of credit Days) < TadayDate, sum(collection))
Try like
Date( [Posting Date] + Purgechar( [No of Days], 'daysDAYS') ) //If Date is pure date format
Or
Date( Date(Date#([Posting Date],'DD/MM/YYYY')) + Purgechar( [No of Days], 'daysDAYS') )
Or
if( (Date( [Posting Date] + Purgechar( [No of Days], 'daysDAYS') )) < Today(), sum(collection))
Or
if( (Date( Date(Date#([Posting Date],'DD/MM/YYYY')) + Purgechar( [No of Days], 'daysDAYS') )) < Today(), sum(collection))
Regards
Anand
Hi Abhay,
Please try:
=Date(Date#([Posting Date],'DD/MM/YYYY') + Purgechar( [No of Days], 'NoOfDays'),'DD/MM/YYYY')
Regards
Neetha
what is daysDAYS?
It is for remove the days string from the field and get only numeric values you can try this way also if there is only days
Date( Date(Date#([Posting Date],'DD/MM/YYYY')) + Purgechar( [No of Days], 'days') )
Regards
Anand
Probably good if you can post up an example app
Hello Abhay,
Does your field value says 1. 20 Days, 10 Days; or 20, 30 etc.
Case 1
Date(PostingDate + PurgeChar(No.of Days,'DAYSdays'),''DD/MM/YYYY)
Case 2
Date(PostingDate + NO.OF Days ),''DD/MM/YYYY)
This Should work