set decimals in expression on dates (1 Viewer)
- Thread starter jedder18
- Start date
- Local time
- Yesterday, 19:59
- Joined
- Jan 23, 2006
- Messages
- 15,379
Yes Mark that's the question re Format.
I think as long as Start and End are Date data type --and these are very poor choices for names -- that something like this (untested) should work.
Total_Time: Round((DateDiff("n",[Start],[End])/60),2)
I think as long as Start and End are Date data type --and these are very poor choices for names -- that something like this (untested) should work.
Total_Time: Round((DateDiff("n",[Start],[End])/60),2)
MarkK
bit cruncher
- Local time
- Yesterday, 16:59
- Joined
- Mar 17, 2004
- Messages
- 8,179
Yeah, or if you do use Format() you can do . . .
. . . but Format(), as far as I know, always returns a string, and if you want to round a number, you usually want a numeric result.
Code:
Format(12.34567890, "0.00")JDraw...I agree, the names are terrible. I'm working on an existing db of anothers' creation and too far in to change the names.
I edited this post....I forgot to put the Round function in...
this formula works...
Excellent. Thanks so much.
I edited this post....I forgot to put the Round function in...
this formula works...
Excellent. Thanks so much.
