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.

Date > Timestamp

3guk
in Calculation Engine (Define Fields)

Featured Replies

Hey Guys,

 

Using a calendar generation script that requires all of my eventstart field and eventend field to be timestamps rather than dates.

 

Since all of my events are dates I've had my database set up with just date fields.

 

Can I use a calculation to generate new fields which take the date field and spit out a timestamp of date + a time of 00:00 ?

 

Any ideas?

 

Thanks

 

James

Use

 

Timestamp ( yourDateField ; Time ( 0 ; 0 ; 0 ) )

    •
    • Like 2

    I believe that GetAsTimeStamp ( theDate ) would works also.  :-)

    •
    • Like 1

    Indeed it does – not as explicit, but less wear and tear on the old keyboard …  :smile:

    less wear and tear on the old keyboard …  :smile:

     

    If that is a concern, consider =

    Timestamp ( Datefield ; 0 )
    •
    • Like 2

    I just love this stuff !  Thanks for the fun guys!


    Wait ... wait ... where's Daniele?

    I'm here ( as Always ) :)
     
    Another way ( simpler )
     

    Datefield  // calculation result TimeStamp

     
    LOL

    •
    • Like 1

    Create an account or sign in to comment

    https://fmforums.com/topic/91431-date-timestamp/
    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.