Formatting Date

[Ron Cates]

Hi all,

A quick one. I am printing the date using Get(CurrentDate) . I would like it to read April 20th 2010 rather than 4/20/2010. How do I do it?

Thanks

[LaRetta]

If it is just for printing, select your date field in layout mode and go to Format > Date and specify your settings there.

YOu are using Get ( CurrentDate)? You can place // on your layout and format the current date using the above technique.

Edited April 20, 2010 by Guest

[Ron Cates]

I am using it to create a templete for a letter. I have a script that populates a field with the contents of the letter including the date which I get using Get ( CurrentDate). So when populating a field with Get ( CurrentDate) is it possible to format it the way I would like?

[LaRetta]

Set your field with this calculation:

Let ( [

dte = Get ( CurrentDate ) ;

y = Year ( dte ) ;

m = MonthName ( dte) ;

d = Day ( dte )

] ;

m & " " & d & ", " & y

)

[Ron Cates]

That did the trick,

Thanks

[Adan Daroski]

Format formatter; // The year formatter = new SimpleDateFormat("yy"); // 02 formatter = new SimpleDateFormat("yyyy"); // 2002 // The month formatter = new SimpleDateFormat("M"); // 1 formatter = new SimpleDateFormat("MM"); // 01 formatter = new SimpleDateFormat("MMM"); // Jan formatter = new SimpleDateFormat("MMMM"); // January // The day formatter = new SimpleDateFormat("d"); // 9 formatter = new SimpleDateFormat("dd"); // 09 // The day in week formatter = new SimpleDateFormat("E"); // Wed formatter = new SimpleDateFormat("EEEE"); // Wednesday // Get today's date Date date = new Date(); // Some examples formatter = new SimpleDateFormat("MM/dd/yy"); String s = formatter.format(date); // 01/09/02 formatter = new SimpleDateFormat("dd-MMM-yy"); s = formatter.format(date); // 29-Jan-02 // Examples with date and time; see also // Formatting the Time Using a Custom Format formatter = new SimpleDateFormat("yyyy.MM.dd.HH.mm.ss"); s = formatter.format(date); // 2002.01.29.08.36.33 formatter = new SimpleDateFormat("E, dd MMM yyyy HH:mm:ss Z"); s = formatter.format(date); // Tue, 09 Jan 2002 22:14:02 -0500

Thanks

__________

Techstore are specialists in a range of Business Cards Printing Services.