Search results for query: *

Thanks, the synapsevampire formula works

I have a formula to calculate the difference in time by seconds, i.e 108,000. When I try to convert to time using crtimefromsecssincemidnight(@total time), I get the error "out-of-range(0-86400). Is the a way to give me the total time 30:00:00 hours? Thanks, Bill B

Thanks for the help. Had to do some minor modification to the formula but works great.

Is there a formula that will allow me to pull data just for every third day in a date range? For example, my end date is today and I want to go backwards to Jan 1st for every 3rd day. This will be a daily report that would give each shift (A,B,C) their cumulative report for data. Thanks for...

Thanks Brian, this worked great with 1 change. In the third line I had to use Currentdate-2 instead of maximum(lastfullweek) to capture the early morning Sunday times. Thanks for the help!! Bill B

Instead of using the filter LastFullWeek, I need a formula that runs Sunday 7:00AM thru next Sunday 6:59AM. I have separate Date and Time fields with time as a string. (Created Date) is a DateTime field but only has 12:00AM as the time. (Created Time) shows as 070000. Any help is appreciated.

I need to group 10 years of data by fiscal year using just a date field (CreatedDate). FY is 10-1 thru 9-30 for years 2005-2014. Is there an easy formula out there? WRB

I am in need of a date formula that runs a 90-day interval for the previous 4 to 2 months prior to current month, i.e it's Nov but I need July1 thru Sept30. Can you help?

How do I create a 24-hour workshift that starts at 7:30AM each day? There are 3 shifts A,B,C that rotate thru the year. I have a date and time field to use in my table. Help?