Skip to main content
Nintex Community Menu Bar
Question

convert text string to datetime field

  • July 10, 2024
  • 1 reply
  • 27 views

Forum|alt.badge.img+14

A have a date field I convert to a string text field I and then converting to a datetime field. The {varTemp_Date_Time_End_No_Time} is 2015-10-28

DATETIMEVALUE (Text(YEAR( {!varTemp_Date_Time_End_No_Time} )) & “-” & Text(MONTH( {!varTemp_Date_Time_End_No_Time} )) & “-” & Text(DAY( {!varTemp_Date_Time_End_No_Time} )) & " 23:59:59")

In the output datetime field in skuid shows as 10/28/2015 7:59 PM.

I thought it would show as 10/28/2015 12:59 PM

Does this have something to do with time zones or my formating? Any ideas?

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+17
  • Nintex Employee
  • July 10, 2024

Salesforce date times do take your local time zone into account and adjust accordingly. 

This is more a Salesforce formula question - not really a skuid question though.  Better handled on the success community.