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 () 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- 12-06-2007
I could be wrong, but... I believe the variable only shows the DD part of your request... SO, to format it as "YYYYMMDD" you'd use "" (no quotes). Likewise, formatting it as "MMDDYYYY" would be "".
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 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 variable. 8)
Hope that helps! :D
-e
tsneller- 11-10-2009
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- 11-12-2009
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):
Displays a date and/or time. For example, 4/3/93 05:34 PM. Date display is determined by your system's LocaleID value.
Displays a date in the format 4-31-2007. This value can include an offset such as to revert to the prior day.
Displays the month in number format. This value can include an offset such as to forward to the next day.
Displays the month in short text format. This value can include an offset such as to forward to the next day.
Displays the month in long text format. This value can include an offset such as to forward to the next day.
Displays the year in short number format. This value can include an offset such as to forward to the next day.
Displays the year in long number format. This value can include an offset such as to forward to the next day.
Displays a date in the format 2007-4-31. This value can include an offset such as to forward to the next day.
Displays a date according to your locale's long date format.
Formats the date as the day. This value can include an offset such as to forward to the next day.
Displays a time using your locale's long time format; typically includes hours, minutes, seconds.
Displays a time using your locale's short time format.
Displays the long date and short time according to your locale's format.
Displays the long date and long time according to your locale's format.
Displays the short date and short time according to your locale's format.
Formats the date as the month. This value can include an offset such as to forward to the next month.
Formats the date as the short month text (Jan, Feb). This value can include an offset such as to forward to the next month.
Formats the date as the long month text (January, February). This value can include an offset such as to forward to the next month.
Formats the date and time as Greenwich Mean Time (GMT).
Formats the date and time as a sortable index.
Formats the date and time as a GMT sortable index.
Formats the date and time with the long date and long time as GMT.
Formats the date as the year. This value can include an offset such as to forward to the next year.
Formats the date as the day of the week (1 to 7). This value can include an offset such as to forward to the next day.
Formats the date as the day of the week short text (Mon, Tues). This value can include an offset such as to forward to the next day.
Formats the date as the day of the week long text (Monday, Tuesday). This value can include an offset such as to forward to the next day.
Formats the date as the day of year. This value can include an offset such as to forward to the next year.
Formats the date as the week of the year. This value can include an offset such as to forward to the next year.
Formats the date as the ISO day of the year. This value can include an offset such as to forward to the next day.
Formats the date as the ISO week of the year. This value can include an offset such as to forward to the next week.
Formats the date as the ISO year. This value can include an offset such as to forward to the next year.
Inserts parameter value. Replace # with the actual parameter number (1, 2, 3...)
Inserts parameter name. Replace # with the actual parameter number (1, 2, 3...)
<#>
Incremental counter set to first available number for exported filename.
Forumer™ is Voted #1 Free Forum Hosting provider
Build your own community today with the largest message board hosting company.