Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions

Default value for Date or DateTime


Reply

6 Posts   4318 Views

Avatar
brokemeister

5 August 2009 at 6:48pm Community Member, 30 Posts

Hi!

I would like to set a default value for Date-DataType. Like the "Current Date" or "Current Date + 2 Days"...
How can I achieve this?

Cheers,

Malte

Avatar
joshy

5 August 2009 at 11:55pm Community Member, 57 Posts

Hiya,

Presuming your field is called 'Date':

$default = array('Date' => strtotime('now + 2 days'));

This should set the date to be today + 2 when looking through the CMS.

Cheers,

Josh

Avatar
Hamish

10 August 2009 at 10:14am Community Member, 712 Posts

Don't think that is quite right.

Looking at the Date class:

1. if it is an array (keyed Day, Month and Year) it will set the date with these values

2. Otherwise, it will try to set from a string by:

   2a. if the date is in the form xx/xx/xxxx it will 'fix' this from NZ/euro d/m/y dates to US m/d/y date string.

   2b. it will execute strtotime and set the value as the 'Y-m-d' string.

So, the following options should all set the date to the first of july 09:

$default = array('Date' => array('Year' => 2009, 'Month' => '5', 'Day' => 1));

$default = array('Date' => "1st July 2009");

$default = array('Date' => "01/05/2009");

So for your example (and reading from [url]http://jp2.php.net/manual/en/function.strtotime.php[/url]) you should do:

$default = array('Date' => "+ 2 days");

Avatar
Benedikt

26 August 2009 at 1:41am Community Member, 16 Posts

Hint: If you use SSDatetime as Data type, it is enough to use:
'Date' => 'now'

Avatar
Hamish

26 August 2009 at 9:57am Community Member, 712 Posts

Anything that is recognised by [url=http://nz.php.net/manual/en/function.strtotime.php]strtotime[/url] will work.

See the [url=http://www.gnu.org/software/tar/manual/html_node/Date-input-formats.html]GNU Date Input Formats[/url] for valid strings.

Avatar
mhanisch

29 January 2014 at 4:11am Community Member, 5 Posts

Hi,
I cannot get this to work with any of the above answers in a SS 3.0.1 project and a SS_Datetime field.

Best regards