Thank you both. While mdmackillop's code has the elegance I was looking for, and was in the same vein as my own explorations, it doesn't seem to give the right results in the first two rows below:
Input Result
16/03/09 13:00 Tuesday 17 Mar 2009 14:00
17/03/09 13:59 Tuesday 17 Mar 2009 14:00
17/03/09 14:01 Tuesday 17 Mar 2009 14:00
19/03/09 13:59 Tuesday 17 Mar 2009 14:00
20/03/09 13:59 Tuesday 17 Mar 2009 14:00
(I suspect it's because Datevalue only returns date with no time element, and Dte has been dimmed as long anyway)
whereas Sagy's longer code seems to give the right results:
Input Result
16/03/09 13:00 Tuesday 10 Mar 2009 14:00
17/03/09 13:59 Tuesday 10 Mar 2009 14:00
17/03/09 14:01 Tuesday 17 Mar 2009 14:00
19/03/09 13:59 Tuesday 17 Mar 2009 14:00
20/03/09 13:59 Tuesday 17 Mar 2009 14:00
So.. can it be improved?
regards,