Recent content by iuphim

How do I do any of that especially the update function? Thanks!

Hi, how do I trim a date to this format mm/dd/yyyy. My current date is in this format mm/dd/yyyy hh:mm:ss. Thanks!

I want to wild card anything that's in a parenthesis that doesn't fall in this format of ( number / alpha). Can anyone help? Thanks!

I like this minimization a lot. My criteria has blown out a bit to be iff([date received] is null, null, iif([term]=40 and [days]=1 and [eterm]>=30and [edays]=1, met, iif([term]=40 and [days]=0 and [eterm]>=30, met, iif([term]=20 and [days]=1 and [eterm]>=10 and [edays]=1, met, iif([term]=20...

Thank you.

That's pretty cool. Thanks! I have a follow up question and anyone can answer this. I want to do another iif statement or whatever way is better to identify if if certain days fall between a certain date then it should categorize to one of the category below. Ex. Category 0-7, 8-16...

not sure I understand what you mean.... sorry highandwild

Thank you all for the prompt reply. This is a great help!!

hi i would like to trim for just the day in a date, please help write this. if 5/25/2010 - i want the "25" part only. Thanks,

Thank you!

I'm trying 5 iif statements in one and it's giving me lots of error. My statement is iif([date received] is not null, iif([compliance]=20, iif([days]>=10, "Met",iif([compliance]=10, iif([days]>=5,"Met","Not Met"),"Not Met"),"Not Met"),"Not Met")) Please help me correct this so it works.

This works for what I need. Thanks Gemma-the-husky!

How can I pull only fields where there are 14 charaters or more? Thanks!

Hi, I have a spreadsheet that has multiple chunks of column headings within the same spreadsheet. In one of the column there are data that are divided by a "|". I would like to find all the data divided by "|" in those column and bring that data down to another column and copy all the remaining...

I'm not sure if this is a VBA issue or a query issue, but I would appreciate any advice anyone can offer. I have a spreadsheet that has multiple chunks of column headings within the same spreadsheet. In one of the column there are data that are divided by a "|". I would like to find all the...