set decimals in expression on dates

jedder18 · Feb 19, 2014

Using Access 2007
Win 7

Total_Time: Format(nz(DateDiff("n",[Start],[End])/60))

This is my expression in a query.
I need to only show 2 decimal places in the results field.
HELP!

jdraw · Feb 19, 2014

What do you think your Total_Time will look like?
I don't see what you are doing with Format

jedder18 · Feb 19, 2014

format the start and end times to number, allowing for blank or null

some answers will be 2.33366666

MarkK · Feb 19, 2014

I think jdraw's point is that the Format() function takes two parameters. You are only passing it one.

jdraw · Feb 19, 2014

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)

MarkK · Feb 19, 2014

Yeah, or if you do use Format() you can do . . .

Code:

Format(12.34567890, "0.00")

. . . 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.

jedder18 · Feb 20, 2014

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.

set decimals in expression on dates

jedder18

Just Livin the Dream!

jdraw

Super Moderator

jedder18

Just Livin the Dream!

MarkK

bit cruncher

jdraw

Super Moderator

MarkK

bit cruncher

jedder18

Just Livin the Dream!

Similar threads

Users who are viewing this thread