Copy Date with Format Assignment
AnsweredI have a button with actions that adds items to a new list.
The date field errors out and I am using the following in my action [[Participants_x0020_Date_x0020_of]].format("mm/dd/yyyy")
I have tried both as an assignment and as a template.
I get error message:
"...failed to add list item String was not recognized as a valid DateTime
-
Hello Freedom Waters,
Please take a look this discussion https://my.skybow.com/hc/en-us/community/posts/360007688060-Date-Field-Format-Error-String-was-not-recognized-as-a-valid-DateTime .
Let us know if it helps you.
We advise you to search in existing discussions your case or problem before creating new one.
Best Regards,
Oleg Kachmar
0 -
I did just that - I am the originator of that post - and if you look at the sample code I provided above - I believe that I have followed the instructions provided in the previous post - HOWEVER I am still getting an error message.
[[Participants_x0020_Date_x0020_of]].format("mm/dd/yyyy")
0 -
Hello Freedom Waters,
Please try to use Function code type of expression to make possible work with javascript code in Expression Builder dialog.
Hope it will help you.
Best Regards,
Oleg Kachmar
0 -
Oleg,
I appreciate you patience with me - however I am not a jave script person and I am not seeing many examples in the documentation that is helping.
Changing to a function - did let the action execute with no errors - however it did not actually copy data the requested action -copying from one list to another list ---again this is the code directly from the expression builder [[Participants_x0020_Date_x0020_of]].format("mm/dd/yyyy");
Any other suggestions - getting Date of Birth is a critical field for us - because of "age" of people will determine the different levels of service we will provide.
Both lists data fields are the same format and set to date only
FYI - I did get FLOW to copy ---BUT I really want SKYBOW to do the work
0 -
Hello Freedom Waters,
Thank you for reply. We are really happy to help you to configure your solution with Skybow app.
Please try to configure your button with action as the following script shows:
I
I'd like to note, that in context of DateTime format denotation, you need to use "MM" if you want to say month, and "mm" for minute.
If you have any other questions don't hesitate to ask us.
Best Regards,
Oleg Kachmar
0 -
Oleg,
Thank you - Thank you!
It worked.
0
Please sign in to leave a comment.
Comments
6 comments