Controls

Re: now() function question

Travis_H — Fri, 31 May 2019 19:33:25 GMT

Perfect! It worked! THANKS

Re: now() function question

Hilary Stoupa — Fri, 31 May 2019 19:06:55 GMT

Sorry - add seconds, not minutes: concat(number(substring(xdDate:AddSeconds(xdDate:Now(), 10800), 9, 2)), "_", number(substring(xdDate:AddSeconds(xdDate:Now(), 10800), 6, 2)), "_", number(substring(xdDate:AddSeconds(xdDate:Now(), 10800), 3, 2)), "_", substring(xdDate:AddSeconds(xdDate:Now(), 10800), 12, 5))

Re: now() function question

Travis_H — Fri, 31 May 2019 18:59:06 GMT

Thanks I keep getting an error.. can you show me how that would look in the function in the message I sent above?

Re: now() function question

Hilary Stoupa — Fri, 31 May 2019 18:48:24 GMT

You should be able to use the addMinutes function to add 3 hrs to a datetime. Let me know if you need more info.

Re: now() function question

Travis_H — Fri, 31 May 2019 18:42:13 GMT

Hi Hilary, The function you wrote worked for me. "concat(number(substring(now(), 9, 2)), "_", number(substring(now(), 6, 2)), "_", number(substring(now(), 3, 2)), "_", substring(now(), 12, 5))" Just one more piece that I need help with. My SharePoint Sever is 3 hrs off from my time. Normally I would add '+(3/24)' to the end of a Now() function, but I can't get that to work. So how would I be able to increase the time piece of your function by 3 hours?

Re: now() function question

rulermon — Mon, 11 Jan 2016 01:32:12 GMT

You are a genius the only thing I would add to this is that if you copy and past his code into an existing concat remove one parantacy from the front and one paranthacy from the end. BUT THANK YOU SO MUCH.... example of it working concat(Node, "_Sweep", "_", number(substring(now(), 6, 2)), "-", number(substring(now(), 9, 2)), "-", number(substring(now(), 1, 4)), "_", PM Tech #, ".xls") SO if you just want to copy it into your concat copy that: number(substring(now(), 6, 2)), "-", number(substring(now(), 9, 2)), "-", number(substring(now(), 1, 4)), Be sure to have a space before any needed comma and only have one comma at the end before the next set of text/field.

Re: now() function question

mattderby — Wed, 03 Jun 2015 13:14:47 GMT

Hilary Stoupa:
I'd guess you have something else setting the field? Maybe check it out in the rule inspector.

Hi Hilary,

Thanks so much Hilary - got it all working! Very helpful advice on here - thanks :)

Re: now() function question

Hilary Stoupa — Tue, 02 Jun 2015 19:52:15 GMT

I'd guess you have something else setting the field? Maybe check it out in the rule inspector.

Re: now() function question

mattderby — Tue, 02 Jun 2015 19:43:47 GMT

Hilary Stoupa:
NaN = Not a Number. You are using number(substring(now(), 12, 5). The time has a ":" in it - thus is not a number. Try substring(now(),12,5) instead.
If you want underscores instead:
concat(number(substring(now(), 9, 2)), "_", number(substring(now(), 6, 2)), "_", number(substring(now(), 3, 2)), "_", substring(now(), 12, 5), "-", userName())

Hi Hilary

Fantastic thanks - I'm at home now but can't wait to test this tomorrow at work!

Just to note though - even though my formula has slashes in it "/" it actually comes up with underscores instead! I don't want underscores, I want slashes.... any idea why the slashes don't work? (and it automatically subs them for underscores?)

Re: now() function question

Hilary Stoupa — Tue, 02 Jun 2015 19:25:28 GMT

NaN = Not a Number. You are using number(substring(now(), 12, 5). The time has a ":" in it - thus is not a number. Try substring(now(),12,5) instead.

If you want underscores instead:

concat(number(substring(now(), 9, 2)), "_", number(substring(now(), 6, 2)), "_", number(substring(now(), 3, 2)), "_", substring(now(), 12, 5), "-", userName())

Re: now() function question

mattderby — Tue, 02 Jun 2015 19:13:53 GMT

Hilary Stoupa:
I'm confused as to what you are trying to do and what your desired result is - can you tell me what you want the outcome to look like (your formula has "/" in it, and there are none in your output, so I'm sort of baffled) and attach a sample form under the options tab?
Thanks!

Hi Hilary

Thanks for taking the time to try and help!

I'm using Scott's formula on the 4th post - so the "/" is there from that. However as you can see from my output - it comes up with underscores instead, although that's not my main problem...

My desired result is to get the time (not the seconds though) added to the filename as well as the month and date (with username after). Using Scott's formula I successfully got the date and month working. However I couldn't get the time to work. I tried the numbers you suggested - but that didn't work either. This is my formula:

concat(number(substring(now(), 9, 2)), "/", number(substring(now(), 6, 2)), "/", number(substring(now(), 3, 2)), "/", number(substring(now(), 12, 5)), "-", Username)

But the 12 and 5 don't seem to work - it results in the NaN. So I get 28_5_15_NaN-username but I want something like 28_5_15_08_10-username (in an ideal world I'd have 28/5/15-08:10-username)

Can you or anyone help get the time working? Thanks :)

Re: now() function question

Hilary Stoupa — Mon, 01 Jun 2015 19:52:03 GMT

I'm confused as to what you are trying to do and what your desired result is - can you tell me what you want the outcome to look like (your formula has "/" in it, and there are none in your output, so I'm sort of baffled) and attach a sample form under the options tab?

Thanks!

Re: now() function question

mattderby — Thu, 28 May 2015 12:21:59 GMT

Thanks Hilary but it still doesn't work?

This is the formula I have:

concat(number(substring(now(), 9, 2)), "/", number(substring(now(), 6, 2)), "/", number(substring(now(), 3, 2)), "/", number(substring(now(), 12, 5)), "-", Username)

It comes up like:

28_5_15_NaN-username

So I still can't get the time to work?

Re: now() function question

Hilary Stoupa — Tue, 26 May 2015 15:02:25 GMT

substring(now(), 12, 5)

Re: now() function question

mattderby — Fri, 22 May 2015 08:44:34 GMT

Sorry to drag up a very old thread - but Scott's post was very helpful. However I can't seem to get it work for the time. I though this would work: concat(number(substring(now(), 10, 4))) Which would show the hour and the minutes (but not seconds) but it doesn't. Anyone can help?? Thanks :)