Search results for query: *

Thanks Datevalue seems to do the trick!

I forgot to mention that the formula contains other pieces that are concatenated together to produce the final output string. So the formula field is not just the date itself. I guess I could split it up to two formulae and then use a text field to string them back together. That way I could...

First step is to add a group to your report. Group by Dept. Add a summary field (count) to the group. This will give you the total number of employees within the group. Add a formula field that takes the new summary count field and divide it by 3 (will need to round or truncate to an...

I'm using CStr ({Command.INV_DATE}, 'MM/dd/yyyy') in a formula to convert a DateTime field to display as a Date without the time component. However, on all the date fields on my report, I use format them to use the Windows default short date (so that each client can have them displayed as they...

I am looking for UDFs that work with long strings. All the ones I can find have a limit of 256 characters. The functions I want are POS and PARSE. One of our developers said he could write the UDFs, but then he found that he would have to write multiple versions. This is because our clients...