Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have small issue on Date issue
REQ:
My date format field: "Wednesday - 02-24-2016"
Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday
it varies day to day
so in this case
the first description max length is 9 which is wednesday
so i need to get the format only DD-MM-YYYY
my max lenght 9 only so while coming to wednesday its alrdy 9 and there is space and - symbol.
here the day coming dynamically....
So how can i do this?
Thanks in advance.
I don't see a difference in viewing it as a dimension vs. measure? All you want to see is the date in YYYYDDMM format? I guess have you tried -> Date(Date#(Right([VIEW DATE], 10), 'MM-DD-YYYY'), 'YYYYMMDD') as measure?
exctly sunny......
we hve taken as measure abve expression...same..
wen we tried with as dimension abve expresion will givng exact date format.
but wen we use as Measure it givng as nulll?
what might be the reason?
Unless you have a field in a dimension which can uniquely show all your dates (new dates in YYYYMMDD), you will see Null(). The purpose of expression is to show aggregation. You can do Avg(Date) if you don't have a unique dimension, but I am not sure how will that be of any help.
Thanks sunny...
i will chk it tommorw and let you know. if i need anything
Thanks for the info ....
Best
Suresh
No problem
Hi sunny,
as a dimension if i use
the previous logic
Date(Date#(Right(AIR_DATE, 10), 'YYYY-MM-DD'), 'YYYYMMDD')
it is timing out the sheet which iam trying to run
throws an error as "calculation timed out"
Is there any other alternative?
Unless you provide more details of what you are trying to do or share a sample, it would be difficult to give much advice man. Is AIR_DATE coming from a table which is not linked to anything else in that particular chart?
Hi chanty,
try this
Date(Date#(KeepChar('Wednesday - 02-24-2016','0123456789'),'MMDDYYYY'),'YYYYMMDD')