Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In my data set I have only Year no date column is there , when I am taking
Max(year) it is giving me 1905 as output . I have tried num() and date#() but still issue is not resolved.
Can any one help me out!!!
Thanx to All
You are not doing max(year), you are doing date(max(year)) and they are different. What are you expecting as output? A date, may be 1-1-maxyear ? if so, try like:
MakeDate(Max(year))
Could you share a screenshot of how your year field data look like?
Data looks to be fine. Can you share your app with only year field and let us try/investigate?
Please find the below attached file.
You are not doing max(year), you are doing date(max(year)) and they are different. What are you expecting as output? A date, may be 1-1-maxyear ? if so, try like:
MakeDate(Max(year))
Thank you , Actually i was only doing wrong