Dynamic Text Date "[d]" Format

gravelkm · Posted: Mon Mar 19, 2007 11:07 am Post subject: Dynamic Text Date "[d]" Format

Hello,

I have been very happy with Crystal Delivery version 7.0.2.3 so far. One suggestion that I feel would be nice to have would be the ability to allow for the display of the current date ([d]) in different formats besides the "locale's short date" format. Examples would be:

"YYYYMMDD"
"MMDDYYYY"
"MMDDYY"
"YYMMDD"

Would this be possible?

Thanks in advance for your assistance.

Kevin Gravelle

theseus · Posted: Thu Dec 06, 2007 11:48 am Post subject: I could be wrong, but...

I believe the [d] variable only shows the DD part of your request... SO, to format it as "YYYYMMDD" you'd use "[y][m][d]" (no quotes). Likewise, formatting it as "MMDDYYYY" would be "[m][d][y]".

To my knowledge, there isn't a way to format the year using only the last two digits ("YY" vs. "YYYY").

You could format the [system] short date to show only "YY", but you'd also have to format it to NOT display the time... Then I think you could use the [g] variable. 8)

Hope that helps! Very Happy

-e

tsneller · Posted: Tue Nov 10, 2009 7:32 am Post subject: Month Name

It would be useful to be able to use the month Name.

I have offices all round the world, and because the USA use a different format to most of the rest of the world, or standard format is dd-mmm-yyyy - Ie 01-Jan-2009.

In fact the Full and abbreviated month names would be useful.

kgroff · Site Admin

Version 8 already has this option...just may not be in the help file yet. I think you want dpms or dpml. ms and ml do the same this also.

Here is the list (yes it is case sensitive):

[G]
Displays a date and/or time. For example, 4/3/93 05:34 PM. Date display is determined by your system's LocaleID value.

[mdy]
Displays a date in the format 4-31-2007. This value can include an offset such as [mdy:-1] to revert to the prior day.

[dpm]
Displays the month in number format. This value can include an offset such as [dpm:1] to forward to the next day.

[dpms]
Displays the month in short text format. This value can include an offset such as [dmps:1] to forward to the next day.

[dpml]
Displays the month in long text format. This value can include an offset such as [dpml:1] to forward to the next day.

[dpys]
Displays the year in short number format. This value can include an offset such as [dpys:1] to forward to the next day.

[dpyl]
Displays the year in long number format. This value can include an offset such as [dpyl:1] to forward to the next day.

[ymd]
Displays a date in the format 2007-4-31. This value can include an offset such as [mdy:1] to forward to the next day.

[D]
Displays a date according to your locale's long date format.

[d]
Formats the date as the day. This value can include an offset such as [d:1] to forward to the next day.

[T]
Displays a time using your locale's long time format; typically includes hours, minutes, seconds.

[t]
Displays a time using your locale's short time format.

[f]
Displays the long date and short time according to your locale's format.

[F]
Displays the long date and long time according to your locale's format.

[g]
Displays the short date and short time according to your locale's format.

[m]
Formats the date as the month. This value can include an offset such as [m:1] to forward to the next month.

[ms]
Formats the date as the short month text (Jan, Feb). This value can include an offset such as [ms:1] to forward to the next month.

[ml]
Formats the date as the long month text (January, February). This value can include an offset such as [ml:1] to forward to the next month.

[r]
Formats the date and time as Greenwich Mean Time (GMT).

[s]
Formats the date and time as a sortable index.

[u]
Formats the date and time as a GMT sortable index.

[U]
Formats the date and time with the long date and long time as GMT.

[y]
Formats the date as the year. This value can include an offset such as [y:1] to forward to the next year.

[w]
Formats the date as the day of the week (1 to 7). This value can include an offset such as [w:1] to forward to the next day.

[ws]
Formats the date as the day of the week short text (Mon, Tues). This value can include an offset such as [ws:1] to forward to the next day.

[wl]
Formats the date as the day of the week long text (Monday, Tuesday). This value can include an offset such as [wl:1] to forward to the next day.

[dy]
Formats the date as the day of year. This value can include an offset such as [dy:1] to forward to the next year.

[ww]
Formats the date as the week of the year. This value can include an offset such as [ww:1] to forward to the next year.

[id]
Formats the date as the ISO day of the year. This value can include an offset such as [id:1] to forward to the next day.

[iw]
Formats the date as the ISO week of the year. This value can include an offset such as [iw:1] to forward to the next week.

[iy]
Formats the date as the ISO year. This value can include an offset such as [iy:1] to forward to the next year.

[PV:#]
Inserts parameter value. Replace # with the actual parameter number (1, 2, 3...)

[PN:#]
Inserts parameter name. Replace # with the actual parameter number (1, 2, 3...)

[#]
Incremental counter set to first available number for exported filename.