Hi,
I created a custom sales report to export as CSV.
On exported file date comes as “mm/dd/yyyy”. I tought I can handle it in excel but some date ranges came as “dd/mm/yyyy”.
How can I set them as “dd.mm.yy”
Thanks
Search forum for [=FD(
Thanks for reply,
I tried many combinations but didn’t work.
Could you please help for formatting date according to the attached image.
Just post what have you already tried?
Something like [=FD(‘DATEFIELD’,dd.mm.yyyy)]
Not sure if it will work (the syntax is correct, but I don’t think Report Tags support inline expressions), but try this where you have O.Date
…
[=FD(O.Date,'dd.MM.yyyy')]
Thanks but as you say it doesn’t work.
There should be a way to do that.
Ok, try the FD()
function in the last section of the report, which is the formatting section …
:"{1}";"{2}";"{3}";"{4}";"{5}";[=FD("{6}",'dd.MM.yyyy')]}
Didn’t work either
That should work… please copy/paste and post the content of your Export Template here so that we don’t need to type it all out from a screenshot.
Sorry about that,
Satış Raporu
Index;Group;Name;Quantity;Price;User;Date;
{REPORT ORDER DETAILS:
<row>,
O.ItemGroup,
O.MenuItemName,
O.Quantity.Sum,
O.Price,
O.User,
O.Date,
:
:"{1}";"{2}";"{3}";"{4}";"{5}";"{6}"}
Satış Raporu
Index;Group;Name;Quantity;Price;User;Date
{REPORT ORDER DETAILS:
<row>,
O.ItemGroup,
O.MenuItemName,
O.Quantity.Sum,
O.Price,
O.User,
O.Date,
:
:{0};"{1}";"{2}";"{3}";"{4}";"{5}";[=FD("{6}",'dd.MM.yyyy')]}
Formatted with comma-separators, 2 decimals on Price, removed Index, and ISO 8601 date …
Order Details
Group,Name,Quantity,Price,User,Date
{REPORT ORDER DETAILS:
O.ItemGroup,
O.MenuItemName,
O.Quantity.Sum,
O.Price,
O.User,
O.Date
:
:"{0}","{1}","{2}",[=F("{3}",'0.00')],"{4}",[=FD("{5}",'yyyy-MM-dd')]}
Preview:
CSV export in Excel …
Thanks a lot. It worked. Probably I made a mistake.