formatting a function

[p***@comcast.net]

I have an iif function that pulls in either a date or a percentage. The date is fine, but when it is a percentage it is a date or a time. How do i format?

[Bob Barrows]

Post by p***@comcast.net
I have an iif function that pulls in either a date or a percentage.
The date is fine, but when it is a percentage it is a date or a time.
How do i format?

There is a Format() function. It returns a string in a specified format.
If that doesn't help, we can't debug what we can't see ...

[p***@comcast.net]

i used format percent and it worked