Syntax for NOW() in date function

[Former Member]

Hi all

What is the syntax for NOW() in Date function? Can anybody help me..

Thanks&Regards

Hema

[Former Member · Accepted solution]

hi

its simple NOW()... this will give you current date.

try this

On your form, have a Date picker field, then go to its properties -> default value as NOW(), you will come to know the syntax

thanks & Regrds

Harsimran

[Former Member · Accepted solution]

Hi

I don't want that picker icon in my form. what can i do for that? Can u help me?

Thanks&Regards

Hema

[Former Member · Accepted solution]

hi

On your form, add input field of type date and set it default value as NOW().

Hope this will solve your problem.

Thanks & Regards

Harsimran

Dont forget to assign points !!

[Former Member · Accepted solution]

hi,

where can i mention type of the input field(Date)?

Regards

Hema

[Former Member · Accepted solution]

Select the Data type as "Date" when you add input field.

Navneet

[Former Member · Accepted solution]

hi

When you add UI element to the form, select input field from the list and below change the Data type to date.

Thanks & Regards

Harsimran

[Former Member]

Here's how I used it.

In VC select an expression box. When creating it, ensure you have the data type DATE selected and provide a field name. If you don't select a date data type, it will not work (the default is text).

In the Data source field section, under the Expression field, select Formula, Under Date Functions select NOW(). You can also format the date

If you want to select yesterdays date, use the following formula:

DADD(NOW(),-1,'d')

[Former Member]

Take a look here for the syntax of available Date functions, together with examples:

http://help.sap.com/saphelp_nw70/helpdata/en/40/a228173435437394f54c56de571ca4/frameset.htm