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
6 replies
Subscribers
7 subscribers
Views
2250 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
With constant search in Forum and also thinking of Get and Set External PV SS, I
harshav
over 8 years ago
With constant search in Forum and also thinking of Get and Set External PV SS, I am still not able to get update One PV of Date and Time type using IFM Manager Could some one Help me in this.
This is my Scenario,
I am having a CDT which contains text, Primary Key and other types which includes a Date and Time as well,
Using IFM manager I am able to update the values for PK and Text values using the below query.
"UPDATE_PMI " & 454 & " SET PV PK = [" &updatePK& "]"&", PV Text1 = [""" &UpdateText1& """]"&", PV Text2 = [""" &pv!UpdateText2& """]"
But when I try adding Date and Time Field it is throwing me an error I updated it like this adding to the above query
PV Date1 = [""" &UpdatedDate1& """]". I also tried with removing the 2 "" and tried as the way like integer, but it is giving me an error like found 9 tokens after parsing.
Could someone suggest how to do it for date and time field.
OriginalPostID-208977
OriginalPostID-208977
Discussion posts and replies are publicly visible
Parents
0
harshav
over 8 years ago
Finally, Thank you so much Srini, it worked perfectly fine. Didn't knew that we can use the Appian functions and rules in [here].Thanks for the help :) :) . good Learning for me :)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
harshav
over 8 years ago
Finally, Thank you so much Srini, it worked perfectly fine. Didn't knew that we can use the Appian functions and rules in [here].Thanks for the help :) :) . good Learning for me :)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data