Birth date generator

Powerful and fully customizable utility that generates data for database testing purposes

Moderator: Support Team

Birth date generator

Postby Kelly » Fri May 13, 2011 7:13 am

I need to populate our test cuustomer database.
All customers must be at least 18 year old. How can I do that with pattern engine?
Kelly
 

Re: Birth date generator

Postby Support Team » Fri May 13, 2011 4:42 pm

Please try to use following pattern. You should change date format, if necessary.

$RDate(YYYY-MM-DD,1930-01-01,$$($Today(YYYY-MM-DD)-18*365))

Limitation: It ignores leap-year as you can see.
Support Team
 
Posts: 256
Joined: Sun Mar 26, 2006 3:48 pm


Return to DTM Data Generator, Flat File Generator and Test XML Generator

Who is online

Users browsing this forum: No registered users and 1 guest

cron