I want to display only date of the datetime field.

I know that there is a option OOB where we can select the date only category, it displays the date part only.

However, i have an issue where when i put a date with say 23:59 hrs it will be converted to next date.

So, i am planing to display the date without rounding it up and then while display in the page edit in SP designer and display only the date part.

Could you let me know, if it is achievable.#

thanks

Hi,

From your description, my understanding is that you want to get date from a date time column in SharePoint Designer.

I recommend to use substring-before to get the date value from the date time column.

Please refer to the link below for more details:

http://stackoverflow.com/questions/9846388/sharepoint-2010-and-advanced-conditional-formating

Or you can use a calculated column instead.

If this is not what you want, could you please provide more details about your page.

Best regards,

Victoria