Short Date attribute

christopherb

All,
I have an OB that stores CC information for a customer. I would like the date to allow input of mm/yy as credit card don't have dd associated to them.

I have a couple of ideas but before I dive into that I thought I would ask.

Thank you

Chris

tford

Chris,

Simply use MM/yy as the format for your date attribute.

Tom

aware_support

You will probably need to store mm and yy as separate attributes (numbers, not dates).

Thanks

christopherb

As Tom said.... if you select date attribute and delete the dd from the selection. So MM/dd/yy becomes MM/dd and create. So far it works in our test environment. We will keep you posted

Chris

tford

Support,

Were you suggesting mm and yy as seperate number fields for potential automated processing of credit card info that a MM/yy display format would not accomodate?

Tom

greg

Yes, I think support is right and that is a better way to do it. Expiry month and year are sent as numbers for credit card processing. Even if you specify MM/yy as the format, I believe the system stores the day as 01 but does not display it.

You can still store as a date and then extract month and year parts of it by using MONTH(BO.CCExpiryDate) and YEAR(BO.CCExpiryDate). Just be aware that YEAR returns a 4 digit number. You then need to take it AS_STRING and extract 2 CHARACTERS_FROM_THE_RIGHT

Craig

Is there a way to have date in mm/dd/yyyy hh:mm:ss format??

tford

Yes, with a timestamp attribute.

Craig

Tom

In the list of formats available for Timestamp attribute i cant see any format which can capture the seconds part . i want the time to be displayed as hh:mm:ss .

aware_support

You can enter your own format - you don't have to select from the list.