[quote author=Bharat_Naik link=1077331704/0#6 date=1077461572]Since you are concerned about Date formating (merging in other than Word), you might have to make one more text field and convert the internally stored date into the format you desired by Sbasic code.
The date is internally stored as YYYY/MM/DD
Let's say Date1 is the date field TextDate it a new text field you are adding
for 12/31/2003 format =============== TextDate = @STR (@MONTH(DATE1)) + "/" + @STR (@DOM (DATE1)) + "/" + @STR (@YEAR (DATE1))
for 31/12/2003 format ============== TextDate = @STR (@DOM (DATE1)) + "/" + @STR (@MONTH(DATE1)) + "/" + @STR (@YEAR (DATE1))
[/quote]
Thanks people :) . . . me being the non programming type ended up working out the following solution to my problem, which works too! LOL . . .
for 12 December 2004 Format . . .
SUPPORTEXPIRES (DATE) - Original Date Field SUPPORTEXPIRESTEXT (TEXT) - Converted Date Format Field
IF @MID(SUPPORTEXPIRES, 6,2) = "01" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "January" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "02" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "Febuary" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "03" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "March" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "04" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "April" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "05" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "May" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "06" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "June" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "07" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "July" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "08" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "August" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "09" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "September" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "10" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "October" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "11" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "November" + " " + @MID(SUPPORTEXPIRES, 1,4) ELSE IF @MID(SUPPORTEXPIRES, 6,2) = "12" THEN SUPPORTEXPIRESTEXT = @MID(SUPPORTEXPIRES,9,2) + " " + "December" + " " + @MID(SUPPORTEXPIRES, 1,4)
|