asked on diff b/w CurrentTime and Timestamp field
How do I write a formula field that calculates the difference between the CurrentTime and my database field {proposal.timestamp}?
I tried datediff function, but that did not work, it did not like me using the crystal function "CurrentTime".
I tried datediff function, but that did not work, it did not like me using the crystal function "CurrentTime".
Crystal Reports
Last Comment
IO_Dork
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
my timestamp includes date and time, so I should be able to use datediff with currentdatetime. I'll try that.
ASKER
ok, that worked, but how to I get the datediff result to show as hours:minutes instead of just a number that represents total minutes?
for example, it is showing a record with a diff of 132 minutes, I want it to display as 2:12.
for example, it is showing a record with a diff of 132 minutes, I want it to display as 2:12.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Thanks James. Too much in other reporting tools where m is minutes and M is months
mlmcc
mlmcc
No problem. It's easy to forget.
James
James
ASKER
Thanks. I'll try this out when I am back at work Monday.