Autopopulate suffix, prefix and intervening holidays when an user fills a leave form

[Yashwanth H K]

I have a requirement in service catalog that, while filling a catalog form "leave application", 

1. on selecting a date from the field " from date" the system should search if there is any holiday in the cmn_schedule table(i.e weekend / national holidays without any gap ) just before the "from date" starts.  if yes, the value should be stored in field called " suffix " in the format (12/02/2024 saturday, 13/02/2024 sunday.. etc)

2. on selecting a date from the field " To date" the system should search if there is any holiday in the cmn_schedule table(i.e weekend / national holidays without any gap ) just after the "to date" ends.  if yes, the value should be stored in field called " prefix " in the format (12/02/2024 saturday, 13/02/2024 sunday.. etc)

3. It should look for the holidays that comes between "from date" and "to date" and stored in "intervening holidays" field in the format " 3 days "

[Yashwanth H K]

Any Help in any capacity is appreciated

Thanks

[Dr Atul G- LNG]

Hi @Yashwanth H K 

It is too much coding need to do, bcz system need to go in each schedule and check the child schedule and bring the data also it depend if user is from  India or US.