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.

Simple file t set it straight

Robert Schaub
in Community Videos, Tips, & Techniques, Articles.

Featured Replies

This is the simplest file to try to solve a long and winded

discussion Here

TimeTest.zip

And a working model for removing the seconds and using 12-hour time instead of 24-hour time, with a fix for AM times not working in the original...

Update: Changed AM test to <= Time( 11, 59, 59 )

TimeTest.zip

  • 2 weeks later...

I couldn't help, experimenting a bit further - and came up with this for your AllTime field:

Filter (

Substitute ( "~" & GetAsText ( StartTime ) ;"~" & Hour ( StartTime ) & ":";Mod(Hour ( StartTime );12) & ":") ;":0123456789" ) & Case(Div ( StartTime ; 43200 );" P";" A")&"M"

...which obviously only works for 7.0!!! What I havn't tested is if it's somewhat faster than you suggestion ...but typecasts does by and large perform quicker, with the risk of being obsolete with next upgrade of the tool.

--sd

Create an account or sign in to comment

https://fmforums.com/topic/28095-simple-file-t-set-it-straight/
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.