Upper Limit (UL)

** **

Lower Limit with Calendar Day:

Example-1

Lower Limit is “0”

02.06.2013

03.06.2013

04.06.2013

05.06.2013

06.06.2013 ——- Sy_datum is current date

For suppose if we set Lower Limit (LL) as “**0“.It will take both 06.06.2013 and 05.06.2013 dates because before current date(06.06.2013) is 05.06.2013 date so by default it take 05.06.2013 and 06.06.2013**

**
**

**Example-2**

Lower Limit is “1”

02.06.2013

03.06.2013

04.06.2013

05.06.2013

06.06.2013 ——- Sy_datum is current date

For suppose if we set Lower Limit (LL) as “**1“.It will take from 06.06.2013 to 04.06.2013 **

dates.

** **

Example-3

Lower Limit is “2”

02.06.2013

03.06.2013

04.06.2013

05.06.2013

06.06.2013 ——- Sy_datum is current date

For suppose if we set Lower Limit (LL) as “**2“.It will take from 06.06.2013 to 03.06.2013 **

dates.

** **

Example-4

Lower Limit is “3”

02.06.2013

03.06.2013

04.06.2013

05.06.2013

06.06.2013 ——- Sy_datum is current date

dates.

For suppose if we set Lower Limit (LL) as “3”. It will take from 06.06.2013 to 02.06.2013

Upper Limit with Calendar day:

Example-1

Upper Limit is “0”

02.06.2013

03.06.2013

04.06.2013

05.06.2013

06.06.2013 ——- Sy_datum is current date

In Upper Limit it will always exclude Current Date.

For suppose, if we set

**Upper Limit (UL) as “0“.It will take 05.06.2013 dates because Upper limit will always excluded Current Date (06.06.2013****). **** **

Example-2

Upper Limit is “1”

02.06.2013

03.06.2013

04.06.2013

05.06.2013

06.06.2013 ——- Sy_datum is current date

For suppose, if we set

to

Example-3

Upper Limit is “2”

02.06.2013

03.06.2013

04.06.2013

05.06.2013

06.06.2013 ——- Sy_datum is current date

For suppose, if we set

** **

Example-4

Upper Limit is “3”

02.06.2013

03.06.2013

04.06.2013

05.06.2013

06.06.2013 ——- Sy_datum is current date

For suppose, if we set

**Upper Limit (UL) as “3”.It will take from 05.06.2013 ****to 02.06.2013 **

Karan LokeshHi Demish,

Please change LL value to “3” for Example-3 of Lower Limit for Calendar day.

Thanks,

Karan Lokesh

Demish ManiyarPost authorHi Karan,

Thanks for the valuable input…I have modified it and please let me know if you have any more suggestions..!!!

Thanks & Regards,

Demish Maniyar

Suman Chakravarthy KFantastic work and I appreciate your understanding on the concept. But you should have posted the screen shots directly on the blog instead of giving below.

Demish ManiyarPost authorHi Suman,

Thank you for the precious suggestion and it helped me lot. Thanks and awaiting for such guidance further….!!!!!

ðŸ™‚

Thanks & Regards,

Demish Maniyar

prabhith prabhakaranGreat work,,,,,

Demish ManiyarPost authorThank you Prabhith Prabhakaran..!!!

ðŸ™‚

Thanks & Regards,

Demish Maniyar

Arunkumar THi Demish..

Very good work…please share as a blog…

Satendra MishraHi Demish,

It is a nice document about generic delta limit.

Regards,

Satendra,

KD JainNice Blog