How about this...

F

Fred Boer

Suppose I have 3 text boxes each of which holds an integer. I want to
concatenate these three integers and turn them into a date value. Is that
possible?

For example

Field 1 = "Day" value of 1
Field 2 = "Month" value of 1
Field 3 = "Year" value of 2009
Field 4 would then contain some sort of rule/code that would take the other
fields, concatenate them into "1/1/2009", and then render that as a date...

And...

Is there some way to do that in reverse? For example, after entering a date
value, break it out into three integer or string values and store those in
three fields?

Thanks!
 
F

Fred Boer

Thank you very much for responding. I am afraid I may have left out an
important piece of information: I am using Infopath 2003... will that
matter?

Thanks...
 
F

Fred Boer

I have the first example working like a charm! Thank you very very much!
Moving on the second...

I have one more challenge before I finish my project... can you suggest how
to take at date value and transform it into the day of the week... i.e.
2009-11-20 turns into "Friday"?

P.S. I would love to rate this article, but I am using Outlook Express as my
newsreader, and I think that request refers to the web-based newsgroups...
 
F

Frederik Van Lierde

Hi Fred

I changed the settings of myInfoPath 2007 to be compatible with 2003.
And the formula gave some errors as you mentionned on my blog

What I found out is that you need to use ; instead of ,
You can't copy the formula into the default value.

I update the blog post.

Tnx for the comment!

Frederik
 
F

Fred Boer

Frederik! You are my favourite person today! This is great! I've been trying
to create an attendance form, and thought it wasn't going to be possible,
but you've solved every problem I had!

Bravo! It may not have been difficult for you but I'd never have figured it
out!

Many Thanks!

--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/


Fred,

Your last challenge, well it wasn't that difficult

Have a look at my latest blog post: Weekday name function in InfoPath,
without code

http://blueinfopath.wordpress.com/2009/11/22/weekday-name-function-in-infopath/Frederik Van Lierdehttp://blog.SilverSandsAssociates.comDo you follow us already? http://witter.com/SilverSands_IT> --> Fred Boer - Amateur Access Enthusiast> Interests: Library software / Z39.50 / Web Services> Freeware Small Library Application availablehere:http://www3.sympatico.ca/lornarourke/>> "Frederik Van Lierde" <[email protected]> wrote inmessagenews:adcf61b5-ae3c-476a-ad6c-acb951edce04@b15g2000yqd.googlegroups.com...>>>> > Hi>> > Good news, all this can be done out of the box>> > From Input Fields -> Date Field: http://ow.ly/DY3C>> > From Date Field -> 3 TextBoxes: http://ow.ly/DY43>> > Let us know if it worked! And if so, don't forget to rate this> > article>> > Frederik Van Lierde> >http://blog.SilverSandsAssociates.com>> > Do you already follow us ? http://twitter.com/frederik_vl- Hide quotedtext ->> - Show quoted text -
 
F

Frederik Van Lierde

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is this possible? 0
Need some PWA help 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
How to use/create code in MS Word to calculate age? 0
Finding the right style field in VBA 0
Link a text box based on drop down box with four options MS Word 365 0
Finding the proper style field and the numbered paragraph value within the style 0
VBA - exporting serial letters to single documents 0

Top