using dates
in [Queries]
|
From: daisy on 24 Mar 2010 18:40 I am wondering if anyone can help me parse a date field and update another field. Here's the situation: I have a date coming thru - for example: 2/1/2010 I need to populate 3 fields based on this date 1) B_Qtr - 2011-1 2) Year - 2011 3) Qtr - Q1 Our FY year is a little different in that it starts in February and has the next year on it -- Thank you in advance!!!!
From: KARL DEWEY on 24 Mar 2010 18:59 Try these remembering data from Format function is text -- 1) B_Qtr - 2011-1 --- Format(DateAdd("m",11,[ActivityDate]), "yyyy - q") 2) Year - 2011 ---- Year(DateAdd("m",11,[ActivityDate])) 3) Qtr - Q1 ---- Format(DateAdd("m",11,[ActivityDate]), "q") -- Build a little, test a little. "daisy" wrote: > I am wondering if anyone can help me parse a date field and update another > field. > > Here's the situation: > I have a date coming thru - for example: > 2/1/2010 > I need to populate 3 fields based on this date > 1) B_Qtr - 2011-1 > 2) Year - 2011 > 3) Qtr - Q1 > > Our FY year is a little different in that it starts in February and has the > next year on it > -- > Thank you in advance!!!!
From: daisy on 24 Mar 2010 19:33 Karl you are awesome - thank you!!!-- Thank you in advance!!!! "KARL DEWEY" wrote: > Try these remembering data from Format function is text -- > 1) B_Qtr - 2011-1 --- Format(DateAdd("m",11,[ActivityDate]), "yyyy - q") > 2) Year - 2011 ---- Year(DateAdd("m",11,[ActivityDate])) > 3) Qtr - Q1 ---- Format(DateAdd("m",11,[ActivityDate]), "q") > > -- > Build a little, test a little. > > > "daisy" wrote: > > > I am wondering if anyone can help me parse a date field and update another > > field. > > > > Here's the situation: > > I have a date coming thru - for example: > > 2/1/2010 > > I need to populate 3 fields based on this date > > 1) B_Qtr - 2011-1 > > 2) Year - 2011 > > 3) Qtr - Q1 > > > > Our FY year is a little different in that it starts in February and has the > > next year on it > > -- > > Thank you in advance!!!!
|
Pages: 1 Prev: Returning all values with a join Next: DateDiff Conversion |