Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Decimal Places
Message
General information
Forum:
Crystal Reports
Category:
Formulas and functions
Environment versions
Crystal Reports:
Crystal Reports .NET
Miscellaneous
Thread ID:
01596144
Message ID:
01596179
Views:
24
Hello,

Found the solution -- CStr(Day({datetime_field}),0).

Thanks,

TFISHER

>Hello,
>
>I am using Crystal Reports 9. I want to extract the day from a datetime. I have used the Day(x) function and I have the day printing; however, the 27th day of February is printing as the 27.00th day of February. I need to get rid of the decimal places and return the whole number. In have tried to use Int(), but it did not work. I can't seem to find a place in the options to set this to a whole number.
>
>A little help please.
>
>Thanks,
>
>TFISHER
Thanks,

TFISHER
Previous
Reply
Map
View

Click here to load this message in the networking platform