ui-only field date format

  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have created a ui-only field that want to turn 6/16/2015 12:00 am into 6/16//2015. 

I selected a date type of "Date".  But it is not clear what goes in the default value or where I tell the field its Date / Time Format and Manipulation value as shown on:
http://help.skuidify.com/m/models-conditions-filters/l/378313
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Its really not that hard.  You just need to select "override metadata"  and select the "date" display type: 



You can leave everything else blank.  It will pull the date time data and express it without the time component.  No Formula needed. 
Photo of Bill Fox

Bill Fox

  • 7,954 Points 5k badge 2x thumb
I also want to show the month and time in separate columns which seems I will need a formula.

The documentation seems it should look like MONTH(My_Date_Field__c)



What am i missing?
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
The key miss in your attempt:  Wrap field name in {{double braces}}  this is a data merge!

There are two formatting options for you.

Month Number:  MONTH({{My_Date_Field__c}})
Month Name:  FORMAT_DATE("MM",{{My_Date_Field__c }})

The "MM" format string comes from our Time Format syntax and allows you to format dates really any way you want.  Look for more information here: http://help.skuidify.com/m/11720/l/129505?data-resolve-url=true&data-manual-id=11720
Just know that your format code has to be wrapped in quotes - its a string that is passed into the formula.   
Photo of Jack Sanford

Jack Sanford, Champion

  • 8,322 Points 5k badge 2x thumb
I'm trying to make a date field default to a value = to the first day of the month of two months from now. I've got a working UI-Only field that renders the text properly, e.g. my date field of 4/28/2016 makes my UI-Only formula field have a value of "6/1/2016", but it's just text. How do I get that value to push into a second date field and have it be read as a date?
Photo of Jack Sanford

Jack Sanford, Champion

  • 8,322 Points 5k badge 2x thumb
Answer - You can have a formula field like that returns your adjusted date as text in the format YYYY-M-D and then pass that successfully to a date field and have it be read as a date. 

for my case, this formula looks like
YEAR({{CloseDate}}+31)+'-'+(MONTH({{CloseDate}})+2)+'-'+'1'