Hi all can anyone help me I had written a code but it is not working. I want if a user booked a leave within 20 days from the current date which he booked then it will prompt a meesage PL need to be applied after 20 days.
For eg. I am the user i want to take leave so i take leave from today date say 10/2/2009 - 11/2/2009 Now here i want
i will not be booked again after 20 days if 20 days passed then again i will able to booked means 30/2/2009 i will booked again please help me its urgent
fd_NestParticipate-------- names field
Nestle Leave Tracker By Name --------- view name
2 ----- where the date column is there
temp:=@GetField(“fd_NestParticipate”);
x:=@Text(@DbLookup(“”:“”;“”:“NLT.nsf”;“Nestle Leave Tracker By Name”;temp;2));
@If(@Adjust(@Now([ServerTime]); 0; 0; 20; 0; 0; 0) > x;
@Prompt([Ok];"Hi Sushant ";“PL need to be applied after 20 days”);“Sorry”);