AnsweredAssumed Answered

Problems with getting days as a form of weeks, years etc,

Question asked by KenL_1 on Oct 28, 2011
Latest reply on Oct 29, 2011 by KenL_1


Problems with getting days as a form of weeks, years etc,


Hi folks, Im a beginner of FileMaker Pro.

I was trying to get a field called "Length" display a correct value in its corresponding unit, which is a calculation field that calculate the Current Date minus the Created Date of a data.

Therefore, the calculation would be Get (CurrentDate) - Joined Date, and this gives the value in Days as default.

However, I want to make the field becomes more "user-friendly'. In which, I tried to use IF statement to get the correct unit. For example, if Get (CurrentDate) - Joined Date < 7, the unit behind the calculated value would be week(s), and if it is over 28, then month(s) and so on. But I have no idea how should I achieve this sort of calculations as all I know about IF statement is that you can only allow a result displayed/filled into a field with "value/text". What I mean here is something like,

If( Get (CurrentDate) - Joined Date < 7 ;  "Length week(s)") 

I know this doesn't make any sense to the calculation but this is the only way I could think of.

And also I don't know how or can I actually Look-up a field's value as a IF statement result once an IF condition is met.

So I hope someone here could help me out or suggest a better solution for it.

Thank you.