Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
eric.rajala

eric.rajala

Blog Posts
  • Profile
  • Activity
  • Communities
  • Friends
  • Mentions
  • Likes
  • Achievements
  • Bookmarks
  • Blog Posts
  • Questions
  • More
  • Cancel
  • AssetWise ALIM | eB - Blog: eQL Example for Extracting Fiscal Year and Quarter From a Date Field

    eric.rajala
    eric.rajala

    Here is a sample report that converts a date field to quarter and fiscal year values

    START WITH Document
    SELECT
    Id,
    CASE
    CAST (DateEffective AS STRING, 'MM') 
    WHEN '10' THEN 'Q1' 
    WHEN '11' THEN 'Q1' 
    WHEN '12' THEN 'Q1'…

    • Tue, Aug 19 2014
Communities
  • Home
  • Getting Started
  • Community Central
  • Products
  • Support
  • Secure File Upload
  • Feedback
Support and Services
  • Home
  • Product Support
  • Downloads
  • Subscription Services Portal
Training and Learning
  • Home
  • About Bentley Institute
  • My Learning History
  • Reference Books
Social Media
  •    LinkedIn
  •    Facebook
  •    Twitter
  •    YouTube
  •    RSS Feed
  •    Email

© 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies