Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
how to get date format .
and i am using this date(date#([Due Date],'DD-MMM-YYYY'),'MMM-YYYY') AS MonthYear1 not getting correct
output.
to Ex: Jan-2017
thanks ,
=Date(Date#([Due Date],'DD-MMM-YYYY'),'MMM-YYYY')
replace the highlighted with the format of your Due Date field.
ex: 12-06-2017
Use this-
=Date(Date#([Due Date],'DD-MM-YYYY'),'MMM-YYYY')
this is the output i got
srrry kamal due date format is yyyy-mm-dd
Hi,
Can you please share the sample data
Regards
What format is of your Input Date? Please Accordingly use the Current Format in the Date#() funtion.
hi ,
Date(Date#([Due Date],'2017-Jun-09'),'MMM-YYYY')as MonthYear1
i am using this and out u can see above which i got but i am looking for attached pic output how can i achieve that.
thanks,
Hi Pradeep,
Please provide the sample input data format that is easy for us.
mahesh ,
sorry due to security reason i cant submit the sample .
please send me logic i can understand .
thanks ,