Jump to content

Reformat Date Field from .CSV import


This topic is 6102 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi, I'm a complete beginner in FMP. (Sorry if this is the wrong forum)

I am using a web database (baseportal) simply because it has a simple interface for mobile access and I will be regularly importing the records from this into FMP. The date field, though, is ugly. Baseportal exports the date as: "YYYY.MM.DD,00:00.00#n#-06:00"

with n being a number 1-9 (I'm not sure what it is yet, I think it might be dependent on the hour of the day I create the record.) Everything after the DD is constant; it is always 00:00.00...

Anyway, I would like the date to be in the form MM/DD/YYYY or at the very least, YYYY.MM.DD as it appears in the original. In other words, I'd like to get rid of the other stuff.

I tried searching for how to do this but I can't find how to change it from YYYY.MM.DD to MM/DD/YYYY. Anyone?

Thanks!

Link to comment
Share on other sites

This topic is 6102 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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