Date conversion XMLport

DigitP

Hi
I want to export the deliverydate via an XMLport
within nav the format is 01/10/17 and i need 10-01-17
is there some Export::OnBeforePassVariable() to convert it ?

with regards

Kishorm

Change the "Source Type" property to "Text" then you need to have something like the following in the Export::OnBeforePassVariable trigger...

YourNodeName := FORMAT(SalesHeader."Order Date");

Kishorm

Try...

TagName := FORMAT(DateField,0,1);

DigitP

i want to format Sales Header::Order Date
cant format it anymore in the CAL code

Kishorm

Change the "Source Type" property to "Text" then you need to have something like the following in the Export::OnBeforePassVariable trigger...

YourNodeName := FORMAT(SalesHeader."Order Date");

DigitP

Hi Kishrom,
Thnx for your awnser
it did the trick did some format conversion 2 based on your awnser

FORMAT("Sales Header"."Order Date",0,'<Day,2>/<Month,2>/<Year,2>');

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]