Hi!
I'm trying to convert this formula into a date/time instead of only date record.
The Status field currently has log edits turned on and I would also need to switch that log to include the time.
If(Contains([Status],"Closed Won"),
ToDate(Left(Right(NotRight([Deal Stage Tracking],"Closed Won"),"["),9)),null)
Is this an easy use of ToTimestamp that I'm just failing at?
Thank You!
Chris
------------------------------
Chris
------------------------------
Question
Log Edits Date/Time Formula
This topic has been closed for replies.
+24Try this
var text DateAndTime = Left(Right([Deal Stage Tracking],"["),18);
var date TheDate = ToDate(Left($DateAndTime," "));
var timeofday TheTime = ToTimeOfDay(NotLeft($DateAndTime,9));
ToTimestamp ($TheDate, $TheTime)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text DateAndTime = Left(Right([Deal Stage Tracking],"["),18);
var date TheDate = ToDate(Left($DateAndTime," "));
var timeofday TheTime = ToTimeOfDay(NotLeft($DateAndTime,9));
ToTimestamp ($TheDate, $TheTime)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.