Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In my data, date is in string format.I want to converted it in to number format.
I used below query for the conversion.
date(date#([AssignEndDt ],'MM/DD/YYYY'),'MM/DD/YYYY') as end_date
but it was not working.
Hi,
You need to take care of format masking.
Can you upload few sample data to look over.
Regards
ASHFAQ
Hi ashfaq,
I attached my data above.
Try like this
date(date#([ProjEndDt],'M/DD/YYYY HH:MM TT'),'MM/DD/YYYY')
or
=date(date#('1/31/2016 12:30 AM','M/D/YYYY hh:mm tt'), 'MM/DD/YYYY')
Regards
ASHFAQ
Hi
date(date#([AssignEndDt ],'M/D/YYYY hh:mm tt'), 'MM/DD/YYYY') as end_date
HTH
Jonathan
Ashfaq,
I tried your query, Again same will be displayed
jonathan,
I tried your query its working now.
Thanks,
Gokul
Try like this
=date(date#('1/31/2016 12:30 AM','M/D/YYYY hh:mm tt'), 'MM/DD/YYYY')
Can you upload your app
Regards
ASHFAQ
Ashfaq,
sorry, I cant upload app.
thanks for your help, date format is changed.
Thanks,
gokul
thank you guys for your help
Regards,
gokul