Newbie Questions

Re: Workout the days between 2 dates and converting different currencies

sanvir — Mon, 16 Aug 2010 14:54:01 GMT

Hi Alec,

I have used your codeless method, but i get an error when i choose the first date, saying that some rules were not applied.

Thanks again for the help!

Re: Workout the days between 2 dates and converting different currencies

Alec Pojidaev — Fri, 13 Aug 2010 17:25:10 GMT

Here is post about data difference: http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

Re: Workout the days between 2 dates and converting different currencies

sanvir — Thu, 12 Aug 2010 14:56:25 GMT

this is what i have tried for the exchange amounts:

            Dim rate1 As String
            Dim Randamt1 As String
            Dim foramt1 As String

            rate1 = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Rate1", NamespaceManager).Value
            Randamt1 = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Randamt1", NamespaceManager).Value
            foramt1 = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Foramt1", NamespaceManager).Value

            Randamt1 = foramt1 * rate1

These field data types are all: text (string)

Re: Workout the days between 2 dates and converting different currencies

sanvir — Thu, 12 Aug 2010 13:55:42 GMT

i havent added the fields for the other exchange amounts, as i am trying to get one portion of it working..

Workout the days between 2 dates and converting different currencies

sanvir — Thu, 12 Aug 2010 13:54:02 GMT

Hi,

I am making an international expense claim form for a client.
on the form, i have two date fields (date from and Date to). i also have a days field which has to work out the amount of days between the two dates.

i have tried the datediff function but i cannot get it working. Is there possibly an easier way of doing this as i have no experience with visual basic and i am trying everything i can find.

the other thing i wanted to find out is working out different currencies:

for instance i have 3 exchange rate fields. I would put in the South African Rand value of these rates.

i would multiply 1 exchange rate amount with the foreign amount to get the rand value.
once the values are worked out, how would i add them up to get a total?

It sounds confusing, but i have attached a picture of the form to give you more/less an idea of what im trying to do.

Thanks in advance!