TIMESTAMP() function
Y
YES Integrations
A formula function that takes in a date/time and returns the number of seconds since 1 January 1970 00:00:00 UT.
For this to be useful the DATE() function would need to be modified to accept timestamp objects and parse as dates, or another function for converting timestamps to dates would need to be added.
This function would simplify some date processing tasks that are difficult in SmartSuite at the moment (such as finding the true difference between two dates in months) and would bring SmartSuite's capabilities in line with the more general processing of dates available in most programming languages
Jon Darbyshire
Hiya YES Integrations, thanks for this post! I have a few more questions for you:
- Can you provide specific examples of the date processing tasks that are currently difficult to perform in SmartSuite?
- Are there any specific programming languages you're referring to when you mention 'more general processing of dates'?
- Could you elaborate on the use cases where finding the true difference between two dates in months is necessary?
Y
YES Integrations
Jon Darbyshire
- finding the difference between two dates in months or years is complicated because DATEDIFF only does calculations in years
- most allow processing of timestamp objects, javascript docs: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/now, python docs https://docs.python.org/3/library/time.html#time.time
- Often an event happens on the same day each month. Telling for any date when the next event should be requires this