Daylight saving conversion need help

[roswelltx]

I have a formula that works:
if {Parameter} in DateTime (2005, 04, 03, 02, 00, 00) to DateTime (2005, 10, 30, 02, 00, 00)
then dateadd ("h", 1, {Parameter})
else {Parameter}

My problem is I don't want to have to limit this to this one years of 2005, I need a way to make it dynamic to be used no matter what year is there. Any suggestions?
Thanks...

 

[synapsevampire]

Consider 3rd party add ons:

http://www.milletsoftware.com/CUT_Light.htm

Ido Millet is one of the strongest contributors to this forum, and his products are first rate.

-k

 

[cambuzzsaw]

I have a combined field that varies it was written before I was born:
"item43458 upc 3456"
"item43458 upc\3456"
"item43458 upc/3456"
"item43458 /3456"
"item43458 \3456"

my job is to capture the upc and create a new column with it
instead of "item43458 /3456" i need to have:
item43458 3456, I've been knocking on walls for a week now. any help please!! thanks