I am facing issue like while I am trying retrieve the data from the data base I am getting Z as default for date , I only need date as MM/DD/YYYY format only. How can I fix this using expression role?

Hi himabindu,
try the text() function.

example: 

• text(today(),  "mm/dd/yyyy")

docs.appian.com/.../fnc_text_text.html

It's worth noting what the 'Z' actually represents: 

The ISO 8601 standard defines formats for representing date-time values as text. The T is just a marker for where the time part begins. The Z is an abbreviation of +00:00 , meaning UTC (an offset of zero hour-minutes-seconds).

This may be more pertinent for datetimes where the time being returned from your database might not be the local time you think it should be.