Method Community

 

Day Date Function Format Choices

Last post 03-30-2016 10:48 AM by Method_Ben. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-18-2016 10:03 PM

    • Jack
    • Top 150 Contributor
    • Joined on 02-24-2016
    • OKC, OK
    • Posts 38

    Day Date Function Format Choices

    For the Date Function, the formats for a day are kinda misleading and the same.

    'Short' is the same as 'DDD'

    'Long' is the same as 'DDDD'


    I get these results when using a session current date/time and when using a specific date.


    I would like to see the sma eoptions given for month here as well, like D and DD

    -Jack
  • 03-30-2016 10:48 AM In reply to

    Re: Day Date Function Format Choices

    Hi Jack,

    Forgive me if Im misunderstanding what you are trying to do here, but the following date functions should work;

    (using todays date 30 March 2016)

    MM = 03

    MMM = Mar

    MMMM = March

    dd = 30

    ddd = Wed

    dddd = Wednesday

    If you enter a lowercase 'm' in the date function, you are returning the Minutes rather than the Month

    -Ben

    Ben Hargreaves
    Senior Support Specialist
    Method:CRM
    b.hargreaves@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
Page 1 of 1 (2 items)