calculate weeks between Hire date and End date of assignment

2:37PM

Summary:

we have requirement to capture number of weeks between start and end date of assignment in offer. we have created an DFF to capture end date while drafting the offer to populate the data. how do we populate number of weeks (this is not being captured on UI) with out selecting any field. and also could some one share the xml tag to populate this. i have tried the below tag it didn't work.

Requirement :

Assignment Period: Start date to End date for a period of XX weeks

Tag used:

<?xdofx:(to_date(****_ATTRIBUTE_DATE2,'YYYY-MM-DD') - to_date(HIRE_DATE,'YYYY-MM-DD')) div 7?>

calculate weeks between Hire date and End date of assignment

Howdy, Stranger!