System Default Date Format - I need just the Date

[nemmeh]

Hey Everyone,

Our software package is sold to a number of different countries that use different date formats obviously.

Certain fields in our software applications database store the date/time values in a single field that is formatted for DateTime. When I drop these types of fields onto a report, some of them I just want to display the Date for and not include the time.

As a practice, I try to use the "System Default Short Format" which formats in DateTime if the field is DateTime. Is there anyway to override it so that I can make a DateTime field actually just display the Date but have it so it still allows me to use the "System Default Short Format" and make it so it doesn't switch the DateTime format to "Custom" when modifying the format of the field and/or formula?

It wouldn't be such a big issue if we didn't have so many international customers, right now as a workaround we've been creating a second set of reports and just manually modifying the format of the DateTime formula and/or field to custom and just choosing Date.

If I do it this way, it goes to custom and the regional options aren't used on the report to actually display the date in a format of DD/MM/YY instead it just shows as MM/DD/YY.


Thanks,

Nem

 

[Durango122]

hi
you could try this
Go to the following key: My Computer\HKEY_USERS\DEFAULT\Control Panel\International

3. Change the date entries, which are formatted USA style (mm/dd/yy) to UK style (dd/mm/yy).

4. Reboot the machine and the Crystal Reports should now display the date in the UK format.










Durango122
Remember to used all fingers when waving to policemen

 

[MrBillSC]

Try using a formula to extract only the date portion of the field. Then you can still use the "System Default Short Format" on the formula field.

// formula {@DateOnly}
Date(table.DateTimeField}

MrBill

 

[nemmeh]

Thanks for the replies everyone..

I found a formula workaround

DateValue({Table.FieldName})

Thx again.

Nem