I need to create a formula that adds employee DOB to today's date. I've tried using system date but I receive an error that the field types are different. Has anyone used system date in a date calculation formula?
Thanks
Hi Lisa,
Are you trying to write the formula in Sage, Report Designer or Crystal?
Hi Lisa,
Would you like me to send you the formula via email or have a remote meeting to write it on your system? Please email me at [email protected]
There are several various DATE functions in Report Designer depending on what you are trying to accomplish. For example if you are trying to calculate the number of days between the system date and the employee's birthdate you would use the DAYS function. To see a list of all the functions in Report Designer, click on HELP, Help Topics. On the CONTENTS tab select Formulas to expand that topic, the go to List of functions.
Is there a reason why you can't just post the formula here?
I sure can, but just to confirm. Did you change the original question posted? My formula subtracts the DOB and gives you the abiliity to get the employee age based off of today's date.
Yes I did, it should be adding the two dates, not subtracting. Thanks
*Community Hub is the new name for Sage City