0

looking to add todays date into sharepoint list so that I can run multiple expiry timelines off other cells. Have looked online and tried the work arounds but can't able to get any working code.

I have tried multiple ways like

  • Created text column as Today.
  • Added another calculated column and put [today] in the calculated field.

If any one have idea about this please let me know

Many thanks.

Jason.

Improve this question
3
  • try calculated column with Now() as formula
    – Monica Jagani
    Commented May 5, 2016 at 5:06
  • 1
    thankyou very much this works well :) now the challenge I have is the difference between two dates works when I use the now() column and a date that's in the past but it gives me a #NUM! error for any date in the future. Any ideas????
    – Jason Watts
    Commented May 8, 2016 at 21:52
  • Can you tell me what formula you have written for calculating difference. I have used following formula and it works : =[Date Time]-Calc where [Date Time] is column of type Date& Time , calc is caluated column with formula Now(). Also return type for above formula is set as "Number"
    – Monica Jagani
    Commented May 9, 2016 at 4:32

1 Answer 1

Reset to default
1

I tried to get your point and also searched on the web for the same.

Please go through this thread Column calculated value to get the current date time? and let me know if it help you.

Thanks

Improve this answer
2
  • thankyou this has resolved the challenge of knowing when dates are within a window.
    – Jason Watts
    Commented May 8, 2016 at 22:01
  • if it helped you then please mark the answer as accepted so that it can help others
    – Codec
    Commented Jun 2, 2016 at 5:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.