Tips and Tricks
 Crystal Reports Forum : Crystal Reports .NET 2003 : Tips and Tricks
Message Icon Topic: Change time to Decimal Post Reply Post New Topic
Author Message
John BIRSA
Newbie
Newbie
Avatar

Joined: 22 Oct 2009
Online Status: Offline
Posts: 3
Quote John BIRSA Replybullet Topic: Change time to Decimal
    Posted: 22 Oct 2009 at 11:41am
Hi people,
 
I have a question for yours,
 
well I need change some hours to decimal, cause I canīt sum the hour.
 
So, do yours help me with that?
 
What can I do?     


Edited by John BIRSA - 22 Oct 2009 at 12:46pm
Thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 Oct 2009 at 7:04am
take you hours and divide by 24.
IP IP Logged
John BIRSA
Newbie
Newbie
Avatar

Joined: 22 Oct 2009
Online Status: Offline
Posts: 3
Quote John BIRSA Replybullet Posted: 23 Oct 2009 at 7:10am
will not let me make that move says:
 
Need a bolean or number here.
 
I guess I need some more, for make that.
 
Will yours help me, please Confused
Thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 Oct 2009 at 7:21am
what's your code?  that sort of message is usually because the statement is incomplete.
 
You are assigning the value using the := ?  I know it a simple question, but I have made this mistake before...
IP IP Logged
John BIRSA
Newbie
Newbie
Avatar

Joined: 22 Oct 2009
Online Status: Offline
Posts: 3
Quote John BIRSA Replybullet Posted: 23 Oct 2009 at 7:33am
Is for crystan, in visual.
 
I know the statement is incomplete. this is :
                 cstr ({DailyInOut20Oct09_.Entrada}) / 24
 
This is a comun misteake, but I canīt found it,
 
I guess, I need to
state the time as a decimal but i dont know how.
Thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 Oct 2009 at 8:06am
cstr ({DailyInOut20Oct09_.Entrada} / 24)
 
you are converting a number to a string, you need to divide on the number not the string.
 
hope this helps
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.