Hi All
I've been frantically searching for some help on my query, however i haven't managed to find anything yet.

Basically it is as follows. I have a spreadsheet with 3 sheets in it. 1st is for all calendar entries within a range (specified at the top of the sheet, and usually 1 working week). The 2nd Sheet is called Updated (here is where i have the problem). The third is called staff, and this contains a list of staff names, and the lastupdate date (the last time the update button was clicked on sheet 1).

When i run the code on sheet one, it searches through everyones calendars listed in the Staff sheet, and displays a table of all appointments within the specified range on sheet 1. Once it has done this, it writes the date and time into Cell E1 of the staff sheet as reference.

What i am trying to do is make it so the Updated sheet shows only appointments with the specified date range, and which have a CreationTime which is after the Last Update (Staff!E1).

The code i have, which works for items in a date range is;

Please Login or Register  to view this content.
However when i try and add the CreationTime to this, it fails

Please Login or Register  to view this content.
I feel i may be handling the dates incorrectly. Note i'm based in UK so all date and times being passed are in UK format.

Many thanks for your help in advance

ta
DC