CSPro Users Forum

Hi all,

I have and application which has a variable which capture Date of Birth (named DOB), now I want to retrieve a year from that given date.
I know if I write this sysdate("YYYY"), I will get a year from it, but that will be current date, today date, I need to get a year from a specific given date.
How do I do in logic?

Thanks in Advance.

Use the dateadd function.

dateadd(MYDATE, -1, "Y")

https://www.csprousers.org/help/CSPro/d ... ction.html

Thanks Josh,

But actually thats not what I meant. Maybe I did not use proper words, this is what I meant;

1. Assume in varioble DOB (Date of Birth) someone enters 20130623, whick means 2013, June 23.
2. Now I want to pick that year, which means 2013 from the varible DOB and put it in another variable called YearBirth.
3. Summary
DOB = 20130623
YearBirth = 2013

How do I accomplish that in logic? The variable YearBirth should get its value from DOB which is year 2013?

Thanks in Advance

Just divide by 10,000 to shift the year to the right by four places and then truncate:

YearBirth = int(DOB/10000)

int(20130623/10000) = int(2013.0632) = 2013