| || |
Datatable Custom Number format setting
I would like to know if any one in our group has faced this issue in QTP data table.
Issue Description :
I have a cell in datatable which contains date in the format d/mm/yyyy. I right clicked on the cell--> selected Custom Number--->date and modified the date format to dd/mm/yyyy. After making this change the date vale for the cell changes from d/mm/yyyy to dd/mm/yyyy.I then save the changes to the datatable.
When I close and re-open my QTP the cell in the datatable remains in the format d/mm/yyyy and does not reflect dd/mm/yyyy.
Can anybody let me know how to make a permanent change to the date format of a cell in datatable.
Re: Datatable Custom Number format setting
Try function CDate(d/mm/yyyy)