Skip to main content
taavonb4494
January 31, 2023
Question

Filtering the date from a DB entry

  • January 31, 2023
  • 2 replies
  • 0 views

Good morning everyone I am trying to filter the day from a recordtype that has the whole date time in the db. When I put this expression in it shows 3/19/2014 800pm edt. I just need it to show the day. How do I accomplish that?

contents: {
a!richTextDisplayField(
value: a!richTextItem(
text: fv!item [rcordtype],
color: local!textcolor,
size: "MEDIUM_PLUS"
)
)
},

    2 replies

    stefanhelzle0001
    Brainy
    January 31, 2023

    Try the text() function: docs.appian.com/.../fnc_text_text.html

    davel001150
    January 31, 2023

    day() function takes a date or datetime as a parameter and returns the day part, or the day of the month, out of the entire date.