Is there a way to format the output of a date field?  I currently have the datetime field coming over with the 01/09/2011 12:00 AM format and I don't want the time, just the date portion.

Thanks!

Kevin

Hi Kevin,

Are you pulling the Dynamic Views data from a Dynamic Forms instance?

If you're using a textbox on your Dynamic Forms for a data stamp, you can use something like this as the default:

SELECT CONVERT( CHAR(12), GetDate(), 101) As DefaultValue

See this example: http://Beta-Springs.com/Dynamic-For...fault.aspx

You can find other formats and tips here: http://www.sql-server-helper.com/ti...rmats.aspx

Hope that helps!  Thanks!
Candace