Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
13 replies
Subscribers
8 subscribers
Views
4016 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I am trying to get the document creation date using below expression function.
Mahesh Sanga
over 10 years ago
I am trying to get the document creation date using below expression function.
documents(local!documentsList,"dateCreated"), It is returning me dates in "2014-09-03 06:45:46.0" format. I am trying to convert that into dd/MM/yyyy format using datetext function. what is the best way to convert the above date format into dd/MM/yyyy ?
i used datetext("2014-09-03","dd/MM/yyyy") to convert but it threw error saying "invalid parameters passed" even for datetext(tostring("2014-09-03"),"dd/MM/yyyy") .
My use case is to get the list of documents from a folder that were created before given date time.
...
OriginalPostID-128967
OriginalPostID-128967
Discussion posts and replies are publicly visible
Parents
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Yes, the year goes at the end for the todate()
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Yes, the year goes at the end for the todate()
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data