Fiscal Year

This article describes an easy way to handle calculation based on fiscal year and quarter

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(15)

You rated this post out of 5. Change rating

2014-07-28

20,848 reads

Display data by fiscal year instead of calendar year

This article provides a simple solution to display any data by fiscal year instead of calendar year.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(34)

You rated this post out of 5. Change rating

2012-08-07

5,846 reads

The first version of my accounting assistant could not find a single purchase of...

Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...

I’m really excited about some growth in Flyway support. I’ve been asking about this...

Comments posted to this topic are about the item Pay for Performance, which is...

WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415

WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;