Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a date format like MM/DD/YYYY,I would like to convert it to YYYY Q format.
Thanks
Try like:
=Year([Your Field]) & ' Q' & ceil(Month([Your Field])/3)
Hi Rajesh,
Try like this:
Date(Ceil(datefield),'YYYY') &'Q' as newfiled
I am not successed with above script.
ex:
Date:
8/8/2014(MM/DD/YYYY format)---i would like to convert it 2014 Q3??
any sugestions.
thanks
=SubField('8/8/2014','/',3) & ' Q' & Ceil(SubField('8/8/2014','/',1)/3)
=Year(Date#('8/8/2014', 'MM/DD/YYYY'))&' Q'&ceil(Month(Date#('8/8/2014', 'MM/DD/YYYY'))/3)
You can replace the date here with your datefield.
Hi Rajesh,
Try like this:
Date(Ceil(datefield),'YYYY') &'Q' &Ceil(SubField(datefield),'/',1)/3) as newfiled
this should work
i didi not get expected output ,i got some thing like Q13953
Date(Ceil([Bookings Date (2)],'YYYY')) &'Q' &Ceil(SubField([Bookings Date (2)],'/',1)/3) as [Booking Quarter],
Thanks
Hi,
Try this,
=Year(Date(DateField, 'MM/DD/YYYY'))&' Q'&ceil(Month(Date(DateField, 'MM/DD/YYYY'))/3)
Regards
Hi,
try like this:
Date(Ceil([Bookings Date (2)],'YYYY')) &'Q' & Date(Ceil([Bookings Date (2)]),'MM')/3 as [Booking Quarter]