is it possible to display a time range in a field?

  • Profile Image
    tammy1973
    Asked on January 12, 2016 at 05:35 AM

    I would like to have a field which shows a date range/period of time to make it clearer to the customer which period they are looking at.

     

    Customer enters the date of their closing balance in one field, e.g. 29.1.16

    The second field is a calculation widget which calculates the start date of the period as the date of the closing balance minus 28 days, e.g. 1.1.16.

     

    Ideally I would have a third field that I'd call 28 day period and which displays 11.1.16 - 29.1.16

    This would then be followed by a forth number field  with the question "what is the lowest amount in your account during this 28 day period?"

     

    Is it possible to display the date range as described as third field above? Many thanks, Tamara

     

  • Profile Image
    tammy1973
    Answered on January 12, 2016 at 07:48 AM

    yes, that's great, exactly what I need, but what formula did you use to get the date range?

  • Profile Image
    BJoanna
    Answered on January 12, 2016 at 12:49 PM

    Thank you, grade4pagasa for providing this solution. 

    @tammy1973 

    Feel free to contact us if you have any other questions.

  • Profile Image
    tammy1973
    Answered on January 18, 2016 at 06:35 AM

    Thank you so much, I have now managed to do it, much appreciated.

  • Profile Image
    Carina
    Answered on January 18, 2016 at 09:40 AM

    Thank you for updating us.

    If you need further assistance please let us know.

  • Profile Image
    AA_C
    Answered on January 18, 2016 at 09:44 AM

    @Randy, You need to get on the staff, good work my friend.