on 08-27-2007 8:14 AM
Hi all
What is the syntax for NOW() in Date function? Can anybody help me..
Thanks&Regards
Hema
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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')
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.