simon4amiee
Registered User.
- Local time
- Today, 17:52
- Joined
- Jan 3, 2007
- Messages
- 109
Hi guys I'm almost there but struggling a bit.
I have 2 date fields which are text dates
Field Name, Field Data, Outcome (What I want it to be)
[DOB], 20090702, 02/07/2009
[StartDate], 20141127, 27/11/2014
I've managed to convert both into date formats using CVDate, but what Im looking for is a calculated field which records the AGE at the start of an episode ([StartDate]) so this would be StartDate minus DOB but that just gives me a number. So I divided that number by 365 which gave me an Age, however the numbers are in decimals eg 67.22222, 1.123478, 30.1245687.
What I need is the age the was excatly on the StartDate, so I though to use the Left function to display ONLY the first 2 digits but again this is great for 2 digit numbers but for single digiits its still showing me the decimal whare as I just require the whole number.
I've probably gone a long way around this if anyone can think of an easier way I would more than obliged to you.
Regards
Simon
I have 2 date fields which are text dates
Field Name, Field Data, Outcome (What I want it to be)
[DOB], 20090702, 02/07/2009
[StartDate], 20141127, 27/11/2014
I've managed to convert both into date formats using CVDate, but what Im looking for is a calculated field which records the AGE at the start of an episode ([StartDate]) so this would be StartDate minus DOB but that just gives me a number. So I divided that number by 365 which gave me an Age, however the numbers are in decimals eg 67.22222, 1.123478, 30.1245687.
What I need is the age the was excatly on the StartDate, so I though to use the Left function to display ONLY the first 2 digits but again this is great for 2 digit numbers but for single digiits its still showing me the decimal whare as I just require the whole number.
I've probably gone a long way around this if anyone can think of an easier way I would more than obliged to you.
Regards
Simon
