Date field with today's date

(0) Share

Report

Posted on by Community Member

Hello,

I would like to have a field that will display the current date at any given time, effectively the same as having the TODAY() function in Excel. Is there a way to do that without script?

Many thanks,

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (1)

Community Member on at

Like (0)

Report

RE: Date field with today's date

It will show date only when user saves record. For first time opening form it will be blank as calculated column only will process formulae on button click(save).

Is there any way it will show today's date even for opening form first time.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Date field with today's date

It will show date only when user saves record. For first time opening form it will be blank as calculated column only will process formulae on button click(save).

Was this reply helpful? Yes No
Sirodjon 82 on at

Like (0)

Report

RE: Date field with today's date

Hi Paul, i tried this but I keep getting an error on Form load - settodaysdate is undefined at Eval

Was this reply helpful? Yes No
Dik Van Vliet 10 on at

Like (0)

Report

RE: Date field with today's date

=NOW()

Was this reply helpful? Yes No
Suggested answer

CRM Trickey on at

Like (0)

Report

RE: Date field with today's date

I'd just set the date to be the ModifiedOn using a Set Value Action. Since the Business Rule will be invoked manually this worked in my scenario.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Date field with today's date

Thank you Paul Really Helpful!

Was this reply helpful? Yes No
empath-e CRM 1,136 on at

Like (0)

Report

RE: Date field with today's date

Just hit upon this myself and this solution worked well for me. Thanks Sean Kelly.

Was this reply helpful? Yes No
iruser2 2,048 on at

Like (0)

Report

RE: Date field with today's date

i'd love to find a way to have a date field on a form that automatically populates with todays date (and can still be changed by the user) without having to save in order to trigger a work flow. The original question does CRM have the equivalent of excel

=TODAY()

that it can automatically populate onto a form without saving, just be there as the form opens?

thanks!

Was this reply helpful? Yes No
Firearm on at

Like (0)

Report

RE: Date field with today's date

Where Sean's answer will do what you need it to, it will not however display a date on the form while creating. The calculated field will not calculate until after saving. That goes for workflows as well. The run "Before" option is disabled in real-time workflow.

Was this reply helpful? Yes No
Suggested answer

Daniel at VNS on at

Like (0)

Report

RE: Date field with today's date

Thank you PaulShore - THIS is what i was looking for!

Was this reply helpful? Yes No