3 character day of week

[nojyttap]

Is there a way to have a date area that shows the the date like this "Fri
5/2/2008"?

I tried a couple of things...obviously there is no choice for that format in
the DataType format. So what I tried was to put in a date picker and a text
box. The textbox had the default value set to pull in the date from the date
picker and the format set to show the date like this "Friday, May 02, 2008".
Then I tried to use another text box and the substring function to cut that
down to just the "Fri". That doesn't work because the date no matter how it
is displayed is only 10 numrical characters long...so you can never get the
day of the week that way.

Any ideas?

 

[Swathi]

Hi,

After getting field1 value as 'Friday, May 02, 2008' use another text box
and put the following as default value.

concat(substring(field1, 1, 3), " ", substring-after(field1, " "))

 

[nojyttap]

I get "200" from 2008 which are the first three characters of the date...no
matter what format you choose. And as I mentioned the "substring" function
seems to only work up to ten characters, even so the first letters of the day
wouldn't be in the same character position due to the number of characters in
the month.