Urgent help in date please!

[#1]

Hi ,

I have a problem in date field as it is showing dates since 1899. This problem happens today. Please can anyone suggest me as I did all search but not successful.

Thanks.

[ashfaq_haseeb]

Hi,

Make you master calendar as last tab.

Load

Date,

Month

Year

etc

From MasterCalenda.qvd(qvd)

where exsists(Date,Date)

Regards

ASHFAQ

[senpradip007]

Can you share your script?

[#4]

Thanks. Please see below

SortMap:
MAPPING LOAD * INLINE [
    Month, MonthSort
    Jul, 1
    Aug, 2
    Sep, 3
    Oct, 4
    Nov, 5
    Dec, 6
    Jan, 7
    Feb, 8
    Mar, 9
    Apr, 10
    May, 11
    Jun, 12
   
];

Calendar:
LOAD Date(Floor(Date),'DD/MM/YYYY')                              as CommonDate,
     Date_TS,
     Today,
     Week,
     Week as %keyCaseWeek,
     Year,
     Text(Month)                       as Month,
     ApplyMap('SortMap',Text(Month))   as MonthSort,
     Day,
     WeekDay,
     Quarter,
     MonthYear,
     WeekYear,
     CurYTDFlag,
     LastYTDFlag,
     FiscalYear,
     FiscalYearStart,
     FiscalWeek,
     FiscalWeekSerial,
     FiscalQuarter
FROM
D:\Qlikview\QVD\Closures_QVD\Closures_QVD_Completions\MasterCalendar.qvd
(qvd);

CurrentFinancialWeek:

LOAD Year,Week,FiscalWeek,FiscalWeekSerial,FiscalYear,FiscalYearStart RESIDENT Calendar WHERE Week=(Week(Today())) and Year=Year(Today())
Order BY Year ASC;

LET curFiscalWeek=Peek('FiscalWeek',0,CurrentFinancialWeek);
LET curFiscalYear=Peek('FiscalYear',0,CurrentFinancialWeek);
LET curWeek=Peek('Week',0,CurrentFinancialWeek);
LET curYear=Peek('Year',0,CurrentFinancialWeek);
LET curFiscalWeekSeq=Peek('FiscalWeekSerial',0,CurrentFinancialWeek);
LET curFiscalYearStart=Peek('FiscalYearStart',0,CurrentFinancialWeek);

DROP TABLE CurrentFinancialWeek;

[dmac1971]

Using that data and my master Calendar everything seems to be fine?

[PrashantSangle]

Hi,

Just check the date format you mention in script level.

use YearName(DateField).

or try with

YearName(Date(Date#(DateField,'DD/MM/YYYY')))

Try with

use YearName(DateField,0,4).

or try with

YearName(Date(Date#(DateField,'DD/MM/YYYY')),0,4)

Regards

[#7]

Thanks, where I need to use this in my script?

[#8]

Thanks. I have checked yours and it is fine. I am not getting where is the problem in mine? Any help please.

[#9 · Accepted solution]

I have found the problem as there is a data reload problem from database and I checked this and reloaded the file again.

Thanks for all replies.