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.

Discussion posts and replies are publicly visible

0 bhanuprakashm over 8 years ago

Hi Harsha,
Can you try with single quote for date and Time field for update
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sagarl511
A Score Level 2
over 8 years ago

Also you can use char() function with Ascii code of double quote or single quote. For e.g - concat(char(34),now(),char(34)) - will return "4/29/2016 9:09 AM GMT+00:00"
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 harshav over 8 years ago

@bhanuprakashm, May be you haven't seen the post properly , Just to remind I have removed the 2 Double Quotes, Leaving me with only one "" and also single quotes are not the syntax for IFM manager as per the Documentation given, thanks for suggesting.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
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
0 sbatth over 8 years ago

Hi Harsha,

Use todatetime function to convert input to datetime format.

eg:
your rule should be as below

="UPDATE_PMI 111 SET PV cdt.datetimefield = [todatetime("""&ri!inp&""")] LIMIT 1"

Hope this helps.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
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