Ads

Saturday, 16 March 2013

Setting default Time with Date in date time column

We can set default date to current date but not time using date time field.
By below trick we can also achieve that

Create New column of Data and Time type --> select Date and Time under Format,
select Calculated value radio button and enter the following:
=Today+"01:30 PM".

 This will set the default time to default current date.

No comments:

Post a Comment

Ads