Skip to main content

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



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.


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?


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.   


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?


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'