Year-Quarter Auto generate ID

[sunilkumarqv]

Hi All,

Need small help to create Year quarter ID that automatically generate the IDs

Examples

Year-Quarter  ID

2011-Q1   1

2011-Q2    2

2011-Q3    3

2011-Q4    4

2012-Q1    5

2012-Q2    6

2012-Q3    7

2012-Q4    8

If you see Year-Quarter Column we have year - Quarter selection .we want write a script need to auto generate IDs based on Year-Quarter  instead of manually creating .

[jagan]

Hi,

I am not sure why it is not working, it should work becuase we are using this condition for dates

If(DataFieldName >= QuarterStart(Today()), Null(),

If possible attach some sample file.

Regards,

Jagan.

[sunilkumarqv]

So,What is here DataFieldName  means

[jagan]

Hi,

DataFieldName is your date field.

Regards,

Jagan.