Hi Everyone,
I want to display the week number, which is no problem, I can get the week number using the datepart formula.
But this returns a number with decimals ie: 34.00
Is there a way to make this formula just the whole number?
I've tried various functions, fix, truncate, round with no joy, has anyone got any ideas?
Thank you
Sue
I want to display the week number, which is no problem, I can get the week number using the datepart formula.
But this returns a number with decimals ie: 34.00
Is there a way to make this formula just the whole number?
I've tried various functions, fix, truncate, round with no joy, has anyone got any ideas?
Thank you
Sue