How about this...

Fred Boer

unread,

Nov 19, 2009, 6:48:41 PM11/19/09

to

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!

--

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

Frederik Van Lierde

unread,

Nov 20, 2009, 4:39:10 AM11/20/09

to

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

Fred Boer

unread,

Nov 20, 2009, 12:51:24 PM11/20/09

to

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...

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

"Frederik Van Lierde" <fred...@blueoceansgroup.com> wrote in message
news:adcf61b5-ae3c-476a...@b15g2000yqd.googlegroups.com...

Fred Boer

unread,

Nov 20, 2009, 5:37:08 PM11/20/09

to

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...

--

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

"Frederik Van Lierde" <fred...@blueoceansgroup.com> wrote in message
news:adcf61b5-ae3c-476a...@b15g2000yqd.googlegroups.com...

Frederik Van Lierde

unread,

Nov 21, 2009, 6:39:52 PM11/21/09

to

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

Frederik Van Lierde

unread,

Nov 21, 2009, 7:17:11 PM11/21/09

to

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 Lierde
http://blog.SilverSandsAssociates.com

Do 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 available here:http://www3.sympatico.ca/lornarourke/
>

> "Frederik Van Lierde" <frede...@blueoceansgroup.com> wrote in messagenews:adcf61b5-ae3c-476a...@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 quoted text -
>
> - Show quoted text -

Fred Boer

unread,

Nov 21, 2009, 10:07:06 PM11/21/09

to

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/

"Frederik Van Lierde" <fred...@blueoceansgroup.com> wrote in message

news:39cb1e6a-5521-4701...@j19g2000yqk.googlegroups.com...
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" <frede...@blueoceansgroup.com> wrote inmessagenews:adcf61b5-ae3c-476a...@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 -

Frederik Van Lierde

unread,

Nov 22, 2009, 2:16:37 PM11/22/09

to

Tnx for the words,

When I saw the formula to calculate the number of day, I saw the
formula used only function InfoPath accepts.
And i love to push Infoath one step further, that is the reason why
companies in Geneva hires us all the time ;)

Frederik Van Lierde
http://blog.SilverSandsAssociates.com

Do you already follow us? http://Twitter.com/SilverSands_IT

Frederik Van Lierde

unread,

Nov 23, 2009, 4:16:40 AM11/23/09

to

Hi Fred,

Tnx for the remark, I found the issue.

The blogpost is updated with the new formula and I tested it for many
date in 2009 and 2010
Can you please check the formula out and let me know if it worked?

Post: http://blueinfopath.wordpress.com/2009/11/22/weekday-name-function-in-infopath/

The updates are:
1. Formula
2. The Rules: Sunday is 0 instead of 7

Frederik Van Lierde
http://blog.SilverSandsAssociates.com

Do you follow us already? http://Twitter.com/SilverSands_IT

Fred Boer

unread,

Nov 23, 2009, 5:12:12 PM11/23/09

to

Working perfectly now! 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/

"Frederik Van Lierde" <fred...@blueoceansgroup.com> wrote in message

news:4f626191-7377-4991...@g23g2000vbr.googlegroups.com...