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 want). Is there anyway I can get CStr() to format with the system date? The help screens give you all the 'string' formats, but does not reference the system format.
I'm using CR XI.
Thanks.
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 want). Is there anyway I can get CStr() to format with the system date? The help screens give you all the 'string' formats, but does not reference the system format.
I'm using CR XI.
Thanks.