Skip to Content
Author's profile photo Demish Maniyar

Generic Delta in Generic Datasource – Upper & Lower Limit

Generic Delta in Generic Datasource:

Lower Limt (LL)

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.

 

/wp-content/uploads/2013/09/1_272569.jpg

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

/wp-content/uploads/2013/09/2_272570.jpg

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

/wp-content/uploads/2013/09/3_272571.jpg

Assigned tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Demish,

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

      Thanks,

      Karan Lokesh

      Author's profile photo Demish Maniyar
      Demish Maniyar
      Blog Post Author

      Hi 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

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

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

      Author's profile photo Demish Maniyar
      Demish Maniyar
      Blog Post Author

      Hi Suman,

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

      🙂

      Thanks & Regards,

      Demish Maniyar

      Author's profile photo prabhith prabhakaran
      prabhith prabhakaran

      Great work,,,,,

      Author's profile photo Demish Maniyar
      Demish Maniyar
      Blog Post Author

      Thank you Prabhith Prabhakaran..!!!

      🙂

      Thanks & Regards,

      Demish Maniyar

      Author's profile photo Former Member
      Former Member

      Hi Demish..

        Very good work...please share as a blog...

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Hi Demish,

      It is a nice document about generic delta limit.

      Regards,

      Satendra,

      Author's profile photo Former Member
      Former Member

      Nice Blog