date diff calc field - weeks as a decimal

[eggwater]

hi there

had a search for this but kind find anything similar..

i have a calc field using a DateDiff function that gives the number of weeks between two dates - i don't want to use days - but i want to use part weeks -

is there a way the function can give the number of weeks as a decimal figure instead of a rounded up/down figure...

many thanks to whoever can help me or point me in the right direction

 

[namliam]

only way is to calc it yourself

eg. (field1 - field2 ) /7
or datediff("d",field1,field2)/7

Hope that helps in some way

Regards

 

[eggwater]

why didn't i think of that

thank you dude...

muchos gracias


erm.. dankzegging

heh heh

 

[namliam]

why didn't i think of that

Uhm what shall i say?

 

[eggwater]

I have no idea

you don't need to say anything do you?

you suceeeded in solving my problem

have a digital beer on me or something

_____
------- foamy head
\ | /
\ / glass
--