hiI have a problem on showing the birthday of employee .
I have a view with first column birthday date and second column is employee name.
and in another form i have Computed text field in which I want to show the name of the employee whose birthday is on that day.
Subject: Birthday Calculation Problem
Use the below formula in the computed value
temp:=@Today;
@DbLookup(“”;“”;viewname;temp;2);
and
-
your view first column should be sorted.
-
The date format for @today and your DOB in the form should have same format for example DD/MM/YYYY. Then only it returns the correct value.
Let me know if you have problem.