2 Replies Latest reply: Aug 30, 2017 5:29 AM by Alison Cooke RSS

    Issue with Numerous Date Field

    Alison Cooke

      Hello Everyone,


      I have 7 unrelated date fields in two tables.

      I would like the same flexibility afforded by a master calendar i.e. being able to analyse via day, week, month etc. How would I do this? Would it be best practise to create a master calendar for each field? Or, to amend each field within their original tables?


      Sorry if this is vague, I hope you can understand my query.


      Here is one of the tables I am referring to. It features the date fields: 

      [Date of Receipt]

      [First Payment Date]

      [Last Payment Date]


      [Loan Recipient Birth Year] is also a date field but I don't think it would be necessary for it to be put into a master calendar.


      Screenshot (105).png