Jump to content
Sign in to follow this  
Brian Panhuyzen

are they dates or timestamps?

Recommended Posts

When I pull Modified Date from an AB record, it shows as a timestamp, but when I search (e.g., to find records that have changed since the last sync, even if that sync was today), the records yielded indicate that the system is only using midnight of the comparison date, not the full timestamp. Is this correct? And if so, how do I do fine searching for the right records, without having to first yield a found set and then filter them one-by-one? Thanks!

AB Search.png

Share this post


Link to post
Share on other sites

Hi Brian, 

"Modified Date" is a date property. The plug-in will convert any timestamp to a date value when passing it to Address Book. If you need to look for records based on a specific time of the date, then you will do some parsing in FileMaker after the records have been pulled in from Address Book. 

Thank you. 

Share this post


Link to post
Share on other sites

Thanks – this is not clear in the documentation. One would expect that as pulling the Modified Date yields a timestamp that the search would also work by timestamp.

There are actually quite a few shortcomings in both the Developer's Guide (where for example it indicates that the property "Phone" is "Phones" – see attached) and the Functions Guide I would hope that PC will work to remedy.

Screen Shot 2018-12-19 at 12.46.35.png

Share this post


Link to post
Share on other sites

Hi Brain,

Thank you for your feedback. I have sent all the information to our Products team to review. 

Thank you. 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.