General

Re: how to take 30 minutes from an =now() formula

Jimmy — Wed, 18 Feb 2015 13:13:44 GMT

You could also use:

substring(addSeconds(now(), -1800), 12, 5)

Re: how to take 30 minutes from an =now() formula

mattsky — Wed, 18 Feb 2015 03:45:06 GMT

Hi All

Just thought id update it myself, i have found out a way of working it is:

concat(substring(addSeconds(now(), -1800), 12, 2), ":", substring(addSeconds(now(), -1800), 15, 2))

Thanks

how to take 30 minutes from an =now() formula

mattsky — Tue, 17 Feb 2015 06:09:37 GMT

Hi All

I think the subject says it all but to give the full story:

I have some browser enabled forms that have a rule populating completed date and time for certain tasks once a field is clicked. The problem is the time that is autopopulating is in a different timezone for my country (australia) so i want to be able to remove 30 minutes from the =now() formula.

Any thoughts or assistance would be great, thanks

FYI im using IP2007 on SP2007.