Concatenate a date field keeping the date format

**rrcrossman** · 12-13-2016, 04:13 PM

I am trying to concatenate a date field and it is not holding the date format. I have tried to use the DATEVALUE and that isn't working either.

concatenate.png

**mike7952** · 12-13-2016, 04:16 PM

This should work

Formula:

Please Login or Register  to view this content.

**rrcrossman** · 12-13-2016, 04:28 PM

Thank you!! I should have been able to figure that out... Brain dead today..

Concatenate a date field keeping the date format

LinkBack

Thread Tools

Rate This Thread

Display

Concatenate a date field keeping the date format

Re: Concatenate a date field keeping the date format

Re: Concatenate a date field keeping the date format

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] date into text while keeping the date in its initial format

Concatenate text, date and time keeping format

When exporting from a Date format field I want to exclude the Time accompanying the date

Concatenate with a Date field

concatenate a field with date and time

How to Join/concatenate a date field with a time field in Excel?

[SOLVED] Keeping date format of a field inserted from an excel database

Bookmarks

Bookmarks

Posting Permissions