locked
Calculate Age using Workflow RRS feed

  • Question

  • Hi,

    I want to calculate the Age using Date of Birth field in CRM with resepective to Today's date using workflow.
    I don't want to use the javascript because i can't execute the jscript if i am importing the data.

    and i also want it to calculate the Age automatically on the basis of Today's date... i.e. it should get updated when calender year changes...

    So need help on this...
    i am able to do using javascript...
    but don't know how to do this using workflow...

    So please help
    Thursday, July 16, 2009 9:52 AM

Answers

  • I would recommend using a pre plugin instead of a workflow plug-in in this case. If you have a workflow plug-in, it will create many instances running in the background if you do an import which will affect performance.

    I have created something similar, you can change my code a little for your use.
    http://blogs.msdn.com/crm/archive/2009/02/27/creating-a-birthday-contact-list.aspx

    However, you might have to create an process to run nightly to update ages daily.
    Darren Liu | 刘嘉鸿 | MS CRM MVP | English Blog: http://msdynamicscrm-e.blogspot.com | Chinese Blog: http://liudarren.spaces.live.com
    Friday, July 17, 2009 12:40 AM
    Moderator

All replies