Calculated column for Now() function

Question

_{Wednesday, May 11, 2016 9:48 AM}

Hi All,

I tried to use the Now() function in a calculated column but it retrieved zero. I need to deduct the now from a start date to calculate duration in a given time.

Are there any alternatives?

Thanks a lot in advance

All replies (4)

_{Thursday, May 12, 2016 6:47 AM ✅Answered | 3 votes}

Hi arevach,

According to your description, you want to calculate the duration between start date and now.

Per my knowledge, you can use DATEDIF function:

https://support.office.com/en-us/article/DATEDIF-function-E2237F26-6145-4986-8867-E0A5EE2EA818

You can create calculated column like this: Created is start date

This works well:

Best Regards,

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].

_{Wednesday, May 11, 2016 10:26 AM | 1 vote}

Hi Arevach,

try the below

http://sharepoint.stackexchange.com/questions/30050/column-calculated-value-to-get-the-current-date-time

Thanks, Kaviya (Please remember to click “Mark as Answer” on the post that helps you) Blog:

_{Wednesday, May 11, 2016 10:40 AM}

Thanks Kaviya.

I tried following this article but it gives a solution to a view but not to implement in a calculated column.

It says that Now() is not supported but can't find an alternative.

Any thoughts?

_{Monday, May 23, 2016 1:23 AM}

Hi arevach,

Any update？

Best Regards,

Last updated on 2016-05-11

Share via

Calculated column for Now() function

Question

All replies (4)

Additional resources