cancel
Showing results for 
Search instead for 
Did you mean: 

Dateserial question

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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

Former Member
0 Kudos

Thank you. I did find the solution you provided online.