VC Issue? Date For InputFields

[Former Member]

Hi All,

We requirement As Follows.

We Have TWO Fileds DATE1 And DATE2.

We Need Dynamically Change According DATE2 To DATE1.

DATE2:17/03/2008

DATE1:17/02/2008

As Per Cahnges in Date2 It Changes Previous Month Date To DATE1.

Please repond ASAP.

Thanks

SubbaRao Chinta

[Former Member · Accepted solution]

The function DADD changes the date according to your parameters, so in your case :

DATE2 = DADD(DATE1,-1,'M')

Regards,

Luba.

[Former Member · Accepted solution]

Hi,

Use the formula mentioned by Luba.Luba is a very Exeperienced person in Visula composer.

Regards,

Govindu

[Former Member]

Hi,

the formula is not working .it has some issue .

Regards,

Govindu

[Former Member]

What issiue does it have ?

[Former Member]

Hi Luba,

I checked the formula as below on SP14 with Flex.

I added four datetype input fileds to a form with default values as below.

Date1:DADD(now(),-1,'M').

Date2:DADD(@Date1,-1,'M')

Date3:DADD(now(),+1,'M').

Date4:DADD(@Date3,+1,'M').

Output is like below.

Date1:Feb 18,2008.

Date2:Nov 30,1899.

Date3:Apr 18,2008.

Date4:Jan 31,1900.

Please let me know ur views and i thought its a bug .

Regards,

Govindu

[Former Member]

Hello,

This is indeed a bug.

There is a patch to SP14, that has a new runtime (Flex2), if you use this runtime the problem is solved.

But please if you want to add, don't use +, just write the number.

Regards,

Luba.

[Former Member]

Hi Luba,

this is not working with Flex2 also.

and I created a Message for the same.

Regards,

Govindu