Results 1 to 3 of 3

Thread: Formula to Change Date to number

  1. 2011-09-23, 03:32 PM #1
    kirstyobrien's Avatar
    kirstyobrien
    kirstyobrien is offline Sugar Community Member
    Join Date
    Jun 2011
    Location
    Denver, CO
    Posts
    32

    Default Formula to Change Date to number

    Sugar Version: 6.2.2
    Sugar Edition: Enterprise On Demand
    Category: Calculated Field
    Operating System: Windows 7

    Good morning,

    I need to change a date to a number so instead of showing as 3/6/2011 12:24pm I would like it to show as 030620111224.

    Is there anyway to do this using the standard formulas in Sugar? (we are on-demand).

    Thanks
    Kirsty
    Reply With Quote Reply With Quote
  2. 2011-09-23, 03:57 PM #2
    andopes's Avatar
    andopes
    andopes is offline A Sugar Hero | Help Forum Moderator
    Send a message via MSN to andopes Send a message via Skype™ to andopes
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Formula to Change Date to number

    Theorically you just need to add new options in the attributes 'date_formats' and 'time_formats' located in config.php

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.
    Reply With Quote Reply With Quote
  3. 2011-09-26, 03:08 PM #3
    kirstyobrien's Avatar
    kirstyobrien
    kirstyobrien is offline Sugar Community Member
    Join Date
    Jun 2011
    Location
    Denver, CO
    Posts
    32

    Default Re: Formula to Change Date to number

    Thanks Andre

    I am using on-demand and didnt think I could change any of the config files etc, is this not the case?

    Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula Builder (calculating date difference)
    By balloondog in forum Developer Help
    Replies: 2
    Last Post: 2011-06-17, 01:26 AM
  2. Date Filter or Formula
    By sbowling in forum Developer Help
    Replies: 2
    Last Post: 2011-05-12, 03:54 PM
  3. How to change the History (Email Archived) Date from Date Modified to Date Sent?
    By williamliani in forum Help
    Replies: 0
    Last Post: 2011-01-05, 01:35 PM
  4. how to change Date validation on Date fields
    By Ezzatdoust in forum Developer Help
    Replies: 3
    Last Post: 2010-11-29, 12:32 AM
  5. History Layout (Change date modifed for due date)
    By vwpower in forum Help
    Replies: 4
    Last Post: 2006-12-27, 05:26 PM

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
  •  

Forum Rules