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
8 subscribers
Views
2423 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
@sagarI511, thanks for suggesting , It didn't work even , My problem is How many double Quotes we have to give for a Date field, it is not in which we will pass the double quotes, if I pass "" this also it is accepting, not that I need to pass it as char(34), but I am not sure of how many I have to give for Date field in IFM manager, Any thoughts on this.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
harshav
over 8 years ago
@sagarI511, thanks for suggesting , It didn't work even , My problem is How many double Quotes we have to give for a Date field, it is not in which we will pass the double quotes, if I pass "" this also it is accepting, not that I need to pass it as char(34), but I am not sure of how many I have to give for Date field in IFM manager, Any thoughts on this.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data