Method:Classic General Q&A

Re: Truncating date/time field in an email

Method_Michael — Wed, 14 Dec 2011 15:15:10 GMT

To update this forum post:

This issue was addressed through consulting time.

-Michael

Re: Truncating date/time field in an email

Fred_D — Tue, 13 Dec 2011 21:09:47 GMT

Method_Michael:
For more detailed instructions it would have to be through consulting time

It's that time again

Please contact me.

Fred

Re: Truncating date/time field in an email

Method_Michael — Tue, 13 Dec 2011 15:05:30 GMT

Fred-

This should be done in button that sends out the emails not in the list builder grid.

-Michael

Re: Truncating date/time field in an email

Fred_D — Mon, 12 Dec 2011 23:48:25 GMT

Method_Michael:
Look for the actions that are merging the Body of the email and do the following:

Add the Date Function action to take the date (Value from row) and format it to be a different format (One without a time)

Add the Character Function action to replace ListBuilder.MemberExpires (Or what ever the field is called) with the formatted date from the Date Function action.

I am editing my ListBuilder grid (Grid Wizard).

In "Step 2," I selected my field "MemberExpires" for Action.

The Action I selected was "Date Function" which opened up another window of choices. None of them were "Value from Row." I do get "Type In," "Action Result," and "Value from Screen."

If I select Value from Screen, I then select "ListBuilder:MemberExpires" from the drop down menu.

Then, under Function, I selected "Format Date" which pops up another blank window with "yyyy-MM-ddd hh:mm:ss yy" underneath it. I tried enter "yyyy-MM-dd" in the box and still got a time stamp when I generated my email after I saved everything.

Reading between the lines, should I be formatting the date somewhere other than the ListBuilder?

Thanks,
Fred

Re: Truncating date/time field in an email

Method_Michael — Mon, 12 Dec 2011 20:58:34 GMT

Fred-

For more detailed instructions it would have to be through consulting time but I will break it down a bit further.

Look for the actions that are merging the Body of the email and do the following:

Add the Date Function action to take the date (Value from row) and format it to be a different format (One without a time)
Add the Character Function action to replace ListBuilder.MemberExpires (Or what ever the field is called) with the formatted date from the Date Function action.

-Michael

Re: Truncating date/time field in an email

Fred_D — Mon, 12 Dec 2011 18:33:15 GMT

Method_Michael:
Using the Date Function action you can format a date to not have the time displayed, once the date is formatted you will have to use a character function and merge in that formatted date into your email.

Michael, can you walk through that a little slower? I opened my ListBuilder (that you made for me) and selected "Action" on the MemberExpires field. From there, none of what you said makes any sense to me and looking at the "Action Guide" isn't helping either. I need "See Spot Run" type instructions.

Thanks!
Fred

Re: Truncating date/time field in an email

Method_Michael — Mon, 12 Dec 2011 18:00:31 GMT

Fred-

Using the Date Function action you can format a date to not have the time displayed, once the date is formatted you will have to use a character function and merge in that formatted date into your email.

-Michael

Truncating date/time field in an email

Fred_D — Sun, 11 Dec 2011 23:41:18 GMT

I have created an email that pulls in a date (MemberExpires) from ListBuilder, but I noticed that it shows as Month-Day-Year (e.g., Dec-12-2011) followed by "12:00 PM."

Is it possible to either remove the time-stamp or truncate the field so that only the date shows?

When I input the date in my Customer table, no time stamp is shown.

Thanks,
Fred