Wednesday, December 31, 2014

Check month and day fields lies between two dates

Hi,


I have two fields which stores month and day separately. I have a requirement where I need to check the month and day fields(in the format MM/DD) should lie between two dates. For example, if I have month and day fields stored as (02/11), then if the user passes from and to dates as 02/11/2012(MM/DD/YYYY) to 02/28/2014, then I need get that record(02/11).


Kindly provide your inputs.


No comments:

Post a Comment