2 Replies Latest reply on Oct 29, 2011 7:54 PM by KenL_1

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

    KenL_1

      Title

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

      Post

      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.