Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
can any one help me as i struck with the requirement
i want to know whether the week is completed or not as my week starts from Saturday ends on friday, my data will be uploaded daily bases so think that data is uploaded till 13 of this month which is incomplete week bcos complete week is till 15/4/2016,so please tell me how to find complete week
thanks in advance
Maybe like
=If(Max(Date) < Floor(WeekEnd(Max(Date),0,5)),'Incomplete','Complete')
Not having real an idea what you are trying to do. Seems your weeks end on Friday? But you want to show Wednesday?
Maybe it's just enough to subtract 2 days:
max(Date(SubField(FiscalWeek,'_',2) -2 ))
Please read these two documents:
I would guess that your week is defined as Monday - Sunday, so the max function is returning the last day of the week hence Sunday.
Try Date(max(Date(SubField(FiscalWeek,'_',2))) -2)
Load
Subfield( FiscalWeek, '-', 1) as current,
Subfield( FiscalWeek, '-', 2) as current1,
Subfield( [FiscalWeek, '-', 3) as current2
Resident table name
im sorry for the unclear question as my week starts from Saturday and ends on friday.my data is uploaded daily so they uploaded until 13/4/2016 so i want to display that date instead of 15/4/16
HI thanks for the response and sorry for not explaning clearly
i want to know whether the week is completed or not as my week starts from Saturday ends on friday, my data will be uploaded daily bases so think that data is uploaded till 13 of this month which is incomplete week bcos complete week is till 15/4/2016,so please tell me how to find complete week
Maybe like
=If(Max(Date) < Floor(WeekEnd(Max(Date),0,5)),'Incomplete','Complete')
thanks for the help
hi Swuehi,
is it possible to display the dates instead of complete,incomplete