Hi,
I was working on a global to extract records from a table which are timestamped. What I would like to do is determine date ranges. Now.. using days this is very easy to do since I can determine current time, and apply the 86400 * days formula to go back in time. However, this does not takes into account months with 30, 31 or 29 days.
What would be the proper way to determine a date range for timestamped records so I can create data ranges taking into consideration the number of days for each month, is there any function for this or do I have to manually celculate the number of days for each month in the past and adjust accordingly?
I was working on a global to extract records from a table which are timestamped. What I would like to do is determine date ranges. Now.. using days this is very easy to do since I can determine current time, and apply the 86400 * days formula to go back in time. However, this does not takes into account months with 30, 31 or 29 days.
What would be the proper way to determine a date range for timestamped records so I can create data ranges taking into consideration the number of days for each month, is there any function for this or do I have to manually celculate the number of days for each month in the past and adjust accordingly?