Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Trying to import a date field that is in YYYY/MM/DD format into a custom date field defined the same way and I end up with question marks in all of the date fields. How do I fix this?


toyoursucces
 Share

Recommended Posts

Trying to import a date field that is in YYYY/MM/DD format into a custom date field defined the same way and I end up with question marks in all of the date fields.  How do I fix this?

Link to comment
Share on other sites

I think the custom date field is only for display. The date is coming in according to how the computer operating system is set up. Try importing into a text field so you can see how the date is formatted. Then import into a field with the same format and then use the text formatting functions to convert to what you want it to be in a separate field.

  • Like 1
Link to comment
Share on other sites

One potential way, if you are using a current version of FileMaker, is to substitute the "/" with a "+" and wrap it in a GetAsDate.

GetAsDate ( Substitute ( $date ; "/" ; "+" ) )

 

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

 Share



×
×
  • Create New...

Important Information

Terms of Use