Newbie Questions

Re: PM or AM with auto time?

Gagan — Tue, 28 Jul 2009 16:52:18 GMT

ran into a problem with my function.

when the time is during nonn (Ex: 12:15:00 PM) my code will make it so it is (00:15:00 PM)

any way to fix this?

Re: PM or AM with auto time?

Gagan — Fri, 10 Jul 2009 13:14:16 GMT

as soon as I read your response, i facepalmed, and said DUH!

~~but when I actually sat down to code it into the rules, I couldnt figure out the formulas.~~

~~Any Help?~~

got it!

used concat(addSeconds(Timenumber, -43200), " ", timeamorpm)

im actually kind of proud of myself since im such a dunce at programming.

Re: PM or AM with auto time?

warrtalon — Thu, 09 Jul 2009 15:46:04 GMT

Subtract 12 hours?

Re: PM or AM with auto time?

Gagan — Thu, 09 Jul 2009 12:23:37 GMT

thanks for the response.

my end goal is to have the sharepoint list show weather it is AM or PM, so that my end-user can view the data right there, and export to excel if needed

EDIT: so i came up with a temp soultion, which included having my submit button, which was coded, also have Rules, which were to set a node to the Fx (substring-after(now(), "T")) then set a node to AM or PM depending on weather the first node was after or before noon and after or before midnight. then set the final node that is displayed on my form to (concat(node1, " ", node2)).

the problem is that the Fx (substring-after(now(), "T") brings up the time in military time, so even though it looks okay when it is AM, when it switches over to PM, military time and the following PM doesnt look right.

basically i need to change my (substring-after(now(), "T")) formula to be normal time, and not military. is there a way to do this?

thanks so much!

Re: PM or AM with auto time?

warrtalon — Wed, 08 Jul 2009 15:47:39 GMT

That's all just display whether it's in InfoPath or SharePoint. The true XML underneath the covers is a raw number...same for both InfoPath and SharePoint.

What is your end goal?

Re: PM or AM with auto time?

Gagan — Wed, 08 Jul 2009 14:35:10 GMT

actually just figured it out,

for those wondering, change the data type to Time, and click format.

EDIT: actually the whole purpose of this form is to submit it to sharepoint, and what i did only changes the display on infopath form, and doesnt submit the data as AM or PM in sharepoint. any ideas?

PM or AM with auto time?

Gagan — Wed, 08 Jul 2009 14:26:00 GMT

hi all,

I'm using the function "substring-after(now(), "T")" to populate current time. is there any way to add PM/AM to that automatically?

Thanks!