Stack Overflow
Stack Overflow

Questions tagged [fiscal]

46 questions
0
votes
1 answer

Denodo/VQL ISO_WEEK

I wanted to work with iso week in Denodo. I could not find any functions or calculations. I wanted to use this code below: GETWEEK("ISO_WEEK", ADDWEEK(CURRENT_DATE(), 1)) Obviously there is no ISO_WEEK function. Have you encountered such a problem…
Ezgi Turalı
  • 1
  • 1
0
votes
0 answers

Create fiscal calendar in pyspark

I did create a fiscal calendar that can be later improvised to create a function in spark. is there a better and simple way that I can change is it more dynamic like first day to choose as starting fiscal date from fiscalyear import * beginDate =…
Jha Ayush
  • 67
  • 8
0
votes
1 answer

How to get the start and end of Fiscal Year in C# based on current date? - Using SSIS Script Task

I created an SSIS Package that reads through existing files and makes changes/moves based on the file names and sheets. I have a C# Script Task that a co-worker wrote which is manually updated for the start and end of the fiscal year; however, we…
IL0v33xc3L
  • 5
  • 5
0
votes
1 answer

Assign Fiscal Year based on data ranges

I am trying to assign the appropriate fiscal year based on date ranges. set fiscal year parameters My data frame contains records of claims where each record shows the 'Date Generated' , 'Claim Amount', and 'Amount Paid'. dataframe The data types…
Niki
  • 13
  • 4
0
votes
0 answers

How to calculate fisc_day_of_wk where my fiscal year starts 12/26/2020, Saturday?

I am using the below query in Redshift: select cast(NEW_SEQ AS INTEGER) as calndr_key , date (datum) as calndr_dt , CAST(to_char(datum, 'ID') AS INTEGER ) as fisc_day_of_wk , CAST(to_char(datum, 'DD') AS INTEGER ) as fisc_day_of_mth ,…
Mala Kumari
  • 1
  • 1
0
votes
1 answer

MDX Get Sales starting from 2 years ago to today

I'm trying to make a dynamic report that pull sales starting from the first day of the fiscal year 2 years ago up to today and rolls forward with each new fiscal year. Our fiscal years don't line up with calendar years. I have little MDX experience…
GigaFluxx
  • 31
  • 6
0
votes
2 answers

Oracle SQL revenue YTD computation

I want to write an oracle SQL query to compute monthly YTD revenue (cumulative sum) for all possible combinations of the given dimensions. There are also some months where there are no transactions and hence no revenue, in this case the previous…
N91
  • 395
  • 1
  • 3
  • 14
0
votes
0 answers

In PowerBI DAX, trying to capture greatest fiscal month user has filtered on

In my PowerBI, the user can filter on fiscal years and fiscal months. In a custom column, I need to capture the fiscal period number of the greatest fiscal month that the user has filtered on. For example, if the user selects fiscal year 2019 and…
Chris M
  • 1
0
votes
0 answers

Printing to fiscal thermal printer issue

I have an project and it support all printer but not the thermal printer(fiscal),In my app i have the option example when u print the receipt u have to choose the printer and the fiscal printer doesnt show there,so ill need to change the code my…
O E
  • 17
  • 6
0
votes
1 answer

How to change month in sqlite

Month start from the 16/09/2019 and ends 15/10/2019 If the fate is the 11/10/2019 i want the month to be 9 instead of 10..it works in vb =(Month(Fields!Id.invdate.value)+IIF(Day(Fielfs!Id.invdate.value)<16,9,10) Mod 12+1 HOW to do in sqlite SELECT…
shabz
  • 9
  • 3
0
votes
0 answers

SQL DimDate with Fiscal Year not =454 or 445 but with Calendar Range

I have a script that is working fine with the exception of the fiscal time start/end. For example, year0601 should be the 1st day of the fiscal year and year0530 should be the last day of the fiscal year every year. However, when the script runs,…
Robert Payne
  • 23
  • 3
0
votes
1 answer

Mathematically calculating the fiscal year 5-4-4 schedule

I am trying calculate the fiscal year and return the date when it is the end of a week on the 5-4-4 schedule. E.g. Fiscal year starts January 1st then I will return the date 5 weeks, 4 weeks, and another 4 weeks. Then repeat 5 weeks, 4 weeks, 4…
Dom
  • 159
  • 1
  • 3
  • 16
0
votes
2 answers

Query to find day number of the fiscal month in oracle SQL

The query should return the day number of the current fiscal month.Check the below query: SELECT * FROM GL_PERIODS WHERE PERIOD_SET_NAME='Fiscal Year' AND period_year =(SELECT DISTINCT period_year FROM gl_periods …
Roly Singh
  • 27
  • 5
0
votes
1 answer

How can I have Dynamic Fiscal Date Range in BigQuery?

Please suggest me how can I change date range dynamically in BigQuery . For example fiscal year 2017 (4-5-4 calendar) had 371 days verses 364 days in fiscal year 2018. I don't want to change this manually every year. Any help would be appreciated.
Ravi Gaur
  • 71
  • 3
0
votes
1 answer

Fiscal year starts in April but I want to use ISO week numbers 14 of 2018 calendar year to week 13 of 2019 calendar year

I am creating a gantt chart in excel for my plan. My formula determines the start week number and end week number, and displays "1" in a cell corresponding for each week number in a timeline. My challenge is how to use this logic when my fiscal year…
Nikita_Che
  • 7
  • 2
1
2
3 4