How to calculate duration of days from current date and an end date field on form ?

[Megha8]

Hi All,

I have a section on a form with a field "Certified on" (Date type). Also, a field "Duration of days" (String type) in which I require the number of days from current date and Certified on date.
Also, The duration may get updated on certified on date change and daily based on current date.

Thanks in advance 

[vikkyk]

Use DateDiff to calculate the days between today and the Certified On date:

DateDiff( Today(), CertifiedOn )

Put this in the Default of the Duration field so it updates when the Certified On date changes and every day.