Skip to main content
Nintex Community Menu Bar
Solved

Storing Dates in Smartbox objects different than display

  • November 16, 2018
  • 6 replies
  • 36 views

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.


 

6 replies

Forum|alt.badge.img+15
  • 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.


 


  • 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).

 

 


Forum|alt.badge.img+8
  • Author
  • Rookie
  • 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!


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

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

 

Thanks for the suggestions.

 

BillK


Forum|alt.badge.img+11
  • 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


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