2. PHPRunner General questions
  3. how to find QUARTER from date using event
This topic is locked

how to find QUARTER from date using event

 		2/24/2011 9:31:49 AM
PHPRunner General questions
I
 iyan.dk author

hi
I know easy to find QUARTER using SQL visual query, but in this case I need to find QUARTER from 'date' using phprunner event,

said, i have a few field, also 'date' field here, I want add new column for QUARTER on list page using phprunner event, how can I do this?, place on what event?


FIELD1 FIELD2 DATE QUARTER

X X 2011-02-22 Q1

X X 2011-04-11 Q2

X X 2011-09-18 Q3

X X 2011-10-10 Q4



regards

IYAN
Sergey Kornilov admin 2/24/2011

If this needs to be a new column - using calculated field in SQL makes perfect sense.
I
 		iyan.dk author 2/25/2011

Hi jane,
its ok using SQL, but i need this query in event, can you point me for this ?



If this needs to be a new column - using calculated field in SQL makes perfect sense.