+ Reply to Thread
Results 1 to 2 of 2

Date formatting issue

  1. #1
    Registered User
    Join Date
    07-19-2011
    Location
    Boston, USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Unhappy Date formatting issue

    I am trying to have a specific date format applied so that I can append it to another identifier. The format I am looking for is like this:

    January 31, 2014 - JAN2014

    December 31, 2013 - DEC2013

    and so on . . Cannot seem to get this figured out . .

  2. #2
    Registered User
    Join Date
    07-19-2011
    Location
    Boston, USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Date formatting issue

    Solved . . . ' Format (Month([source1].[date]), "mmm" & Year([Source1].[date])

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date formatting issue
    By semantics in forum Excel General
    Replies: 1
    Last Post: 09-17-2013, 04:32 PM
  2. date formatting issue
    By MP3265 in forum Excel General
    Replies: 6
    Last Post: 02-06-2013, 03:13 PM
  3. Date Formatting Issue
    By hey_ray in forum Excel General
    Replies: 3
    Last Post: 02-02-2012, 02:59 PM
  4. Another date formatting issue
    By machepap in forum Excel General
    Replies: 2
    Last Post: 11-22-2011, 11:14 AM
  5. Formatting Date Issue
    By monty4u1 in forum Excel General
    Replies: 3
    Last Post: 11-24-2009, 12:04 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1