Date Time Parsing

Centerprise uses .NET date formats to parse and format date strings.  You can read more about these formats here:

http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

 

If you have an incorrect format, Centerprise will give you this error:

"Cannot convert <some datetime as text> to date using format <some custom format>."  If you see this error, it is a problem with the format provided.

 

Common Errors

  • Using 'm' for month.  The correct character is 'M'.  The lowercase is for minute.
  • Using 'h' to try and parse times that are in a 24 hour format.  Use 'H' for this purpose.
Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    Cory Redden

    Can anyone help me figure out how to change date format from m/dd/yyyy to YYYY/MM/DD

Please sign in to leave a comment.