+ Start a Discussion
jgreene.ax1178jgreene.ax1178 

Create new date/time field

Hi all!

 

I have EE and I'm trying to figure out a way to make a date/time field that updates once a record is created.  

 

I can make the date field no problem, but adding the time in is beyond me.

 

Any help is appreciated!

 

Thank you!

LegendLegend

Hi,

 

Try using the below format:

 

yyyy-mm-ddT00:00:00Z

(e.g.: 2012-03-16T01:02:03Z)

jgreene.ax1178jgreene.ax1178

Maybe I should be more clear - I have  workflow rule that updates the field I'm trying to create.  I can get the day to come in by using the TODAY( ) formula, but I still want the time also. 

 

Does that make sense?

SuperfellSuperfell

use NOW() instead, although you do know there's a standard field that track when the record was created.

jgreene.ax1178jgreene.ax1178

Thank you, I will try that.

 

Yes, I'm aware - but I need the field to track all of the way through lead and contact for different lifecycle statuses.  

 

Will NOW () work with a text field?  Sorry for all of the questions.

 

Thanks again!