Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

A problem when importing dates

Dave E
in Calculation Engine (Define Fields)

Featured Replies

I'm importing data from a text file and parsing it (using the "middle" function). One of the data elements is a date (needed for subsequent calculations), but FM seems to read it as a number and converts that number to a date, which is not the date originally imported.

How can I resolve this? I searched previous threads, but couldn't find anything similar.

Thanks

Dave

You are probably going to have to use some text and date functions depending on how the import looks. Try this one and if it doesn't work, let me know what format it is in (i.e. is it 1/1/02, or 01/01/2002, or Jan 1, 2002, etc.)

Date(LeftWords(Text Date, 1), MiddleWords(Text Date, 2, 1), MiddleWords(Text Date, 3, 1))

HTH

Lee

smirk.gif

  • Author

Thanks...that does the trick.

And I'm embarrassed that I asked the question... I should have remembered that!

Dave

Create an account or sign in to comment

https://fmforums.com/topic/14167-a-problem-when-importing-dates/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.