Sent Date Value To Excel - get Text cell type.

[matancha]

Hi.

In my models i hold a variable call "vDF" that representing user date format (On open trigger --> run macro...)

In my models - I'm use calculated dimention: '=Date(Date, vDF)', to show the date according to the user.

My problem is: When i'm send chart to excel, i'm get the calculated dimention from TEXT type.

                         My question is - How can i send this calculated dimention to excel and get Excel DATE type, in excel worksheet (for group in pivot tables).

Example attached:

Chart with 2 dimention column:

     1st column - Date(Date, vDF),        When sent to excel       --> Excel Text type - That the Problem!!. (I want date type...)

     2nd column -  "Date"                       When sent to excel       --> Excel  Date type - for comparison.

image whith excel's results.

It is possible?

Thanks -

Matan.

[er_mohit]

hii

try with use of format

that your excel works

like

date(Datefieldname,'DD-MM-YYYY')

[matancha]

Thnks er.mohit for your quick answers, but it's not work for me.

Actually-this is what the variable "vDF" does (look at the down-left corner vDF = DD/MM/YYYY).

That's my problem...

Matan.

[matancha]

in my example, Date is also fieldname...

[er_mohit]

i can't open your file because i use personal edition

try this

if vDF is variable

then in script write

Date($(vDF) + RowNo() -1) AS TempDate

then it will give you date

make sure you have create theat variable using LET statement i.e   vDF

[matancha]

vDF is set OnOpen trigger (acoording to user OS language).

User doesn't run the script. Server run the script, and users opening the models in server.

Script solution does not help here.

Thnks again -

Matan.