Skip to main content
Nintex Community Menu Bar

Cannot use formatdatetime function on a datetime field in SharePoint

  • August 19, 2016
  • 1 reply
  • 8 views

Forum|alt.badge.img+7


 

Symptoms


Getting errors in K2 Studio that will not let user to format datetime (FormatDateTime) saying the field needs to be datetime, but they are date time fields in sharepoint (as list column of type date/time).
Error message "The value given to parameter DateTime should be of type DateTime".
 

Diagnoses


N/A
 

Resolution

This has been logged as a bug and will be addressed in a future release.
The suggest workarounds are as follow:
-1- Transfer the date field to a K2datafield (Date) and use the K2datfield in the process.
-2- Another workaround is to use the Convert To ? Date/Time expression to first convert the input parameter instead of just dragging it into the expression ( Navigate to context browser and select Function Browser andgt Conversion andgt To DateTime )




 

1 reply

  • August 16, 2017

Has this been resolved? I am still having this same issue.