on 03-25-2010 3:21 PM
Hello,
Could someone please let me know what exactly this function is doing?
Dateserial (2010, 03+1, 1-1)
Would it be 2010 February 28th??
Not sure about the last 2 digits...
if appt date is 2010 03 25 what would this do??
@Appt Date >=dateserial(year(currentdate),month(currentdate)-1,1) if appt date is 2010, 03 25
@Appt Date <=dateserial(year(currentdate),month(currentdate,1)-1
Thanks!
When you are in the formula editor hit the F1 key and help will come up. The search on the formula name:
Examples
The following examples are applicable to both Basic and Crystal syntax:
DateSerial (1999, 6, 15)
DateSerial (2000, 1 - 7, 15)
DateSerial (1999, 1, 166)
All three return the date June 15, 1999. The second says that 7 months before January 1, 2000 is June 15, 1999. The third says that the 166th day of 1999 is June 15, 1999.
DateSerial (1996 + 12, 2 + 13, 29 + 14)
Returns April 12, 2009. What it means is that 12 years, 13 months and 14 days from February 29, 1996 is April 12, 2009.
Thank you
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.