Posts by fearless2002uk

    I have a field called Delivery Date and one called Hire Period I need to add them together to produce a field called collection date. I can do this in a form, but I think that I need to be able to do it in a table. My ultimate aim is to be able to produce a filter which selects all the records which have a specific Delivery Date or a specific Collection Date. Maybe I need to be able to select records with an instance of a specific date in any field. But how?
    Many thanks in advance.

    I have a spreadsheet with a column of 3500 numbers (in this format 20030129 or 19971112 for example) they are infact dates - I am struggling to format them as such. HELP!

    Many thanks in advance