Divide Decimal By Date Formula

ricky76

Is it possible to divide a decimal by a date formula. In my example the user can enter their amount eg. 300 and then a date formula eg 3M. With these two values i want to be able to split the amount by the date formula entered. In the example i would then get an answer of 100 as the 300 is divided by the number of months. Any help would be most appreciated.

garak

And what for date formula you will allow? What is with CM+5M-1D ?

ricky76

They will only be able to add a simple date formula such as 5D, 3M etc etc.

MBerger

Then why use a dateformula ? It would be much easier to just use 2 fields : one for the amount and one for the period. Advantage is that your have your number to divide AND that you don't have to write difficult code to make sure the user does NOT enter a formula like CM +2W -1D.