Calculated field is changing date from MM/DD/YY to  12345 format
I have a date field [ProjectDate] and I have a second calculated field that I am inserting a hyperlink over this date [ProjectDateCALC].[ProjectDate] shows in MM/DD/YY format like I need, but when I apply the calculated field below it is converting the date to a number format. Can someone please tell me how to adjust my calculation to put it back to MM/DD/YY format? [ProjectDateCALC] =("<DIV><a href="&[URL1]&">"&[ProjectDate]&"</a></DIV>")The result is displaying the date as 39388 instead of 11/02/07Linda Chapman | SharePoint Consultant | My Blog: http://LindaLeeChapman.Spaces.Live.com
February 19th, 2010 4:19am

hi Linda, Rewrite your formula like this [ProjectDateCALC]=("<DIV><a href="&url1&">"&TEXT(ProjectDate,"mm-dd-yy")&"</a></DIV>") It should work.--- Rajesh | My Blog MCTS - WSS AD, WSS Config, MOSS Config.
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2010 5:21am

Thank you so much for your fast response. This was just driving me crazy!Linda Chapman | SharePoint Consultant | My Blog: http://LindaLeeChapman.Spaces.Live.com
February 19th, 2010 5:37am

Glad to hear that. :-)--- Rajesh | My Blog MCTS - WSS AD, WSS Config, MOSS Config.
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2010 7:32am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics