Method Community

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

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

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

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:

1. Add the Date Function action to take the date (Value from row) and format it to be a different format (One without a time)
2. 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.

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.

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

Fred-

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

-Michael

Method_Michael:

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

It's that time again

Please contact me.

Fred

To update this forum post:

This issue was addressed through consulting time.

-Michael