date format as EEE MM/dd/yyyy

[rbross]

Hello,

I need to display a date in a grid as EEE MM/dd/yyyy EEE is for the day of week Mon, Tue, etc
When I use that format on the attribute in the BO It displays nothing in the grid.

Do I need to store the date format I want in a text attribute and use a date function to get the name for the day of the week and use string date MM/dd/yyyy then concatenate them together?

Thanks.

[rbross]

Looks like 'EEE' is not a supported AwareIM date format yet.

I added a 'DateString' Attribute and used this rule to convert the date and get the format I needed.

BOname.DateString=CHARS_FROM_LEFT(DAY_OF_WEEK(BOname.Date),3)+' '+AS_STRING(BOname.Date,'MM/dd/yyyy')

AwareIM support, it would be nice to have this date format like we do with 'DAY_OF WEEK' function so we don't have to convert it all the time.

[Jaymer]

try ddd

[intra]

Hi Roger,

Here's the full Java 'SimpleDate' document that should give you all the options.

https://docs.oracle.com/javase/7/docs/a ... ormat.html

[customaware]

Looks like 'EEE' is not a supported AwareIM date format yet.

I added a 'DateString' Attribute and used this rule to convert the date and get the format I needed.

BOname.DateString=CHARS_FROM_LEFT(DAY_OF_WEEK(BOname.Date),3)+' '+AS_STRING(BOname.Date,'MM/dd/yyyy')

AwareIM support, it would be nice to have this date format like we do with 'DAY_OF WEEK' function so we don't have to convert it all the time.

In some places it supports EEE and in other places it is ddd dd/MM/yy

Cant remember exactly which and when off the top of my head but try both.

[rbross]

try ddd

I started with that and it did not work. Keep in mind the format was entered under the Format property on the attribute on the BO. If you look at all the available formats to choose from 'EEE' is not included in any of them. Also in the user's guide 'E' is no list in supported formats.

[rbross]

Looks like 'EEE' is not a supported AwareIM date format yet.

I added a 'DateString' Attribute and used this rule to convert the date and get the format I needed.

BOname.DateString=CHARS_FROM_LEFT(DAY_OF_WEEK(BOname.Date),3)+' '+AS_STRING(BOname.Date,'MM/dd/yyyy')

AwareIM support, it would be nice to have this date format like we do with 'DAY_OF WEEK' function so we don't have to convert it all the time.

OK, instead of trying to store the format in the BO as EEE MM/dd/YYYY I could try to just use AS_STRING(MyDate,'EEE MM/dd/yyyy') and see if that works.
In some places it supports EEE and in other places it is ddd dd/MM/yy

Cant remember exactly which and when off the top of my head but try both.