hi have data which consist of date such as
i have to retrive 2/2/2016 if i use monthstart function means it is showing 2/1/2016 pls help me
no Kushal if i use monthstart means it gives me 2/1/2016 but my output should begin the first data which is present in the given data as2/2/2016
Date(Monthstart(Date),'MMM-YYYY') as MonthYear
date(min(Date)) as FirstDate,
1 as FirstDateFlag
group by MonthYear;
Now you can write the expressions as
What is the logic of First date here?
You mean to say first date of this year?
Where you want to use this?
=LastWorkDate(Monthstart(Max(CAPITAL_FLOW_TRANSACTION_DATE)),1) using this v can find the latest months first date
Great that you have achieved your output..
Retrieving data ...