Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
'Q' & ceil(month(TempDate)/3)
what is q in the above statement plz help me to understand the above statement.
Thanks in advance
Ferha Jafri
It is just a charachter
Actually this statement is used to create Quarter like Q1,Q2 etc
Here & is used to concatenate.
Actually month(datefield)/3 makes the quarter
It is just a charachter
Actually this statement is used to create Quarter like Q1,Q2 etc
Here & is used to concatenate.
Actually month(datefield)/3 makes the quarter
Thanks i got it
'Q' just a user defined symbol in the form of character for indicating the quarter.
you can also write anothe symbol in the place of 'Q'.