Date format completely messed up in Message to User Pop-up.....

  • 29 September 2016
  • 2 replies
  • 1 view
S
Userlevel 3
Badge +16

This is doing my head in.

 

I am using a Load method to add a DATE/TIME Smartobject field to a Data Label:

In the SQL table it looks like this: 2016-09-29 15:12:52.000

 

The data label has data type text and i use a style Name of Date and Time using Type: Long date

 

When i run the form, the data lable shows 29th September (THIS IS CORRECT)........... great you think, so whats the problem.

 

I want to display that Data lable in a rule to "Show a message to the User"

I create a message and add the Data Label to the body of the Message.

 

I run the form and the Message pop-up displays the date as "2016-09-29 14:12:52Z"

 

WHYYYYYYYYYYYYYYY? Not only is it not displaying the long date, it's using the Zulu Format which is one hour behind......

 

Why are the simple things in K2 such a chew on???

2 replies

T
Badge +3

Hi @Sharpharp1,


 


I was able to create the same problem and I think I found a work around. If you create a new data label with an expression that uses the Format Date and Time inline function (under Date and Time) and use the data label that has the DateTime that you wish to display in the Message Pop-up and then enter in a format type (dddd, mmmm dd, yyyy for example for long date) and then display that new data label in your message box it should display in the correct format.


 


Hope that helps!


11336i0C5516A98EFC5443.png
S
Userlevel 3
Badge +16

Thanks Thomas,

 

K2 support recommended the same method as you using expressions.

Thanks again for helping

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings