Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Daylight saving conversion need help

Status
Not open for further replies.

roswelltx

Technical User
Aug 31, 2005
21
US
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...
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top