I want to convert datetime value into MonthName.

In Page Body, there is a textbox whose value is in "mm/dd/yyyy" form. So I want it in "dd MonthName yy" format. How to do it.

Suppose the field name is field1 which has date in dd/mm/yyyy format, use this in the value expression

DatePart("dd", field1) & " " & MonthName(field1) & " " & DatePart("yy", field1)

|||

It's acually even simpler than that.

In the format properties of the textbox enter in the Format Code: box (top left of tab)

dd MMMM yyyy to return a date such as 03 Novermber 2006

or

dd MMM yyyy to return a date such as 03 Nov 2006