Some of our documents issued to customers has a field to display the date when printed. This value is created from the @Now formula and the field is configured as follows:
Type: Computed Date/Time
Pref: Custom
Show: Only month, day and year
Format: WDMY (d, mmmm, yyyy, w)
Sep:
This create something like:
november 17, 2005
How can I get the first letter to be a capital letter (November 17, 2005) ?
Subject: Capital letter in month (@ Now)
Roger, I’ve just tried your example and I DO get a capital so it’s like this ‘17 November,2005’
The LONG date format on my Windows 2000 PC is set to ‘dd MMMM YYYY’. Is this the difference
Subject: RE: Capital letter in month (@ Now)
I’ve checked my settings (Win XP SP2) and there does the month start with small letter.
Why you and I gets different result on this I don’t know.
Subject: RE: Capital letter in month (@ Now)
Could this be a language setting in the OS ? Some regions (France ?) don’t capitalize month names.
Subject: RE: Capital letter in month (@ Now)
You could do a column formula:
colTime := @Now
M := @Mid(@Text(colTime);" “;” ")
M1 := @If(M=“1”; “January”; M=“2”; “Febuary”; etc)
Then build the column based on that…
colday := @Left(@Text(ColTime);" ");
colMonth := M;
colYear := @Right(@Text(ColTime);" ");
colMonth+" “+colday +” "+colYear
–there is a better, faster way to parse this - just for illistration–
make sense?
Subject: Capital letter in month (@ Now)
How about changing your formula to@Propercase(@Now)
Subject: RE: Capital letter in month (@ Now)
Thanks, but this didn’t help.
By using your example I first got an error since @Now had to be a string and when I changed to:
@Propercase(@Text(@Now))
the result was
17.11.2005 14.00.16.
I still need inputs on this issue.