In a calculated date/time column (Column 1) I wish to display the result of Column 2 minus 1 day and have it displayed as a date not a decimal and append or concatentate a time to that value. For example Column2 = 10/15/2010. I wish Column 1 to display 10/14/2010 7:00 AM. The goal is to have a workflow pause until that specific date and time then execute. Thanks

Sir, You just can create calculated column from the list and inside the formula file type this =[column2]-1 When you create calculated field, choose date and time on The data type returned from this formula is I just tried and it works