Hi all,
I have a calculated column in a MOSS document library that compares two date columns and returns a text value.
The problem is that the comparison is 100% correct because one column is a DateTime (Date & Time) column and the other is just a DateTime (Date only) column.
Is there a way in the formula to convert the datetime field to just the date?
Here is the formula I am currently using:
=IF([ATQ Date]="","No ATQ",IF([ATQ Date]Deadline,"No")))
Thanks in advance,
Alex
Alex Clark
SharePoint Consultant
Intelligent Decisioning Ltd
www.id-live.com
http://sharepointcoding.wordpress.com
@sharepointalex
MCTS: WSS 3.0 Config / WSS 3.0 Dev