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.

Featured Replies

Okay, next question: Is it possible to use the value in a timestamp field to derive a date or time value for another field? I.e., timestamp field value is "2/15/06 3:15pm", calculated fields might be Date2 with value "2/15/06" and TimeMed "3:15pm".

I did look in online Help, but didn't see anything along those lines. Any suggestions appreciated!

You could make both calculation fields simply equal the timestamp field - setting the type of result to Date or Time is enough to extract the relevant portion.

If you need to convert explicitly (for example to use the result in further calculations), use GetAsDate ( timestamp ) and GetAsTime ( timestamp ).

Create an account or sign in to comment

Important Information

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

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.