Skip to main content
Nintex Community Menu Bar
Solved

Storing Dates in Smartbox objects different than display

  • November 16, 2018
  • 6 replies
  • 3 views
  • Translate

Forum|alt.badge.img+8

I am sending an email which includes a date.

 

When it is displayed in the form/view it displays as MM-DD-YYYY.  However when you include the date field from the smartbox object in an email message, it formats the date as YYYY-MM-DD.  It is in this format when you list it out with K2Management.

 

Can you change the email to display the date to the way it is displayed within the form/view?

 

Thanks!

 

BKlaege

Best answer by boringNerd1

Hi,


 


In your workflow designer, look for the inline functions in the context browser. There should be a function called Format Date and Time which allows you to format your date. Check out the help document here on how to use that function to format your date.


 

View original
Did this topic help you find an answer to your question?

6 replies

Forum|alt.badge.img+15
  • 498 replies
  • Answer
  • November 19, 2018

Hi,


 


In your workflow designer, look for the inline functions in the context browser. There should be a function called Format Date and Time which allows you to format your date. Check out the help document here on how to use that function to format your date.


 

Translate

  • 3 replies
  • November 20, 2018

When using the Format Date Time function, you may find the following article helpful:

 

https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

 

This will give you the many options that are avaible for formating, such as MM (Month) and mm (Minutes).

 

 

Translate

Forum|alt.badge.img+8
  • Author
  • 64 replies
  • November 20, 2018

I want to store the date in the format it is YYYY/MM/DD, but present it within an email as the more readable format.

 

It sounds like I need to just keep it as a separate field.  At least that is what I am pursuing.

 

Thanks!

Translate

Forum|alt.badge.img+8
  • Author
  • 64 replies
  • November 20, 2018

formatting the date in another field marked invisible using an expression is what I needed.

 

Thanks for the suggestions.

 

BillK

Translate

Forum|alt.badge.img+11
  • 658 replies
  • November 20, 2018

When using a SmartObject of Date or DateTime the actual value is always stored in a standard format.  Only the visual display of the data is changed with control styles or with the formatting function.


David

Translate

More on.....C# Date and Time

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings