Let's say I have a date (not a datetime) value. For example, September 9, 20

prestonb over 9 years ago

Let's say I have a date (not a datetime) value. For example, September 9, 2014. Right now I'm displaying this value on a form using this expression: datetext(rf!dBusinessDate, "dd MMMM yyyy")

Different users see different values depending on what time zone they are in and its relationship to GMT. Some people see 9 Sep. Others are seeing 10 Sep. What I really want is for everyone in every timezone to see 9 September. How do I format dates so that they do not get adjusted?
...

Discussion posts and replies are publicly visible

0 vanmathyv
Certified Lead Developer
over 9 years ago

Hi Preston,

You can try text(rf!dusinessDate, "dd MMMM yyyy") function to achieve your use case.
Here is the link for your reference for text() function,
forum.appian.com/.../Text_Functions.html

Datetext function interprets the date specified in the user's preferred calendar and returns its string representation using given format.
Here is the link for datetext() function,
forum.appian.com/.../Scripting_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel