Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Usually a date in such columns as CreateDate and UpdateDate and also #CurrentDate# reference is in technical format that is inconvenient for app's interface.


As an example, the #...backend@CreateDate# reference will show in app's UI as:


image 1

Image Added

This is how this date is pulled from #...backend@CreateDate# hashtag.


HOWEVER, for the UI you can only want to have a part of this date, for example:


image 2

Image Added



To achieve this transformation you can use a transformation MASK for the date's hashtag "@formatDate(X,Y)", where "X" is how it should loo, and "Y" is how it does look:


As an example, you can add this MASK to transform date from image 1 to image 2:

#...backend@CreateDate@formatDate(MM/dd/yyyy,yyyy-MM-dd HH:mm:ss.SSSSSS)#

Image Added

No spaces between expressions and commas please!


IMPORTANT:

  1. Standard notation is used for denoting parts of date (yyyy, dd, etc)
  2. The Mobsted standard date format for all of its automatic system fields in objects, events etc is always yyyy-MM-dd HH:mm:ss.SSSSSS
  3. You can use this mask function for any other date transformation, not only from platform's fields but also any other fields, including TEXT, however please make sure that the format of your custom recorded date can be described in a standard notation of point 1 above.



As always, let us know if you need any other date transformation - [email protected]