Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a chart Dynamic and i have on field format date "YYYY-MM-DD" and i want to have this format "DD/MM/YYYY"
there is a way to do that knowing i remove and i add the field to chart dynamic
i try this Settings ==> Document Prop ==>Number ==> Number Format Settings ==> Date"DD/MM/YYYY"
but doesn't work ?
i use QV 11 SR2
Many thanks for your help
Best Regards,
Emteam
use date function
DATE(field,'DD/MM/YYYY')
HTH
Sushil
date(date#(fieldname,'YYYY-MM-DD'),'DD/MM/YYYY')
Hi,
1. Try this one.
Ex: Date(DateFieldName,'DD/MM/YYYY')
2. if you have string format use this one. This syntex convert string format to Date format
Ex: Date(Date#(DateFieldName,'DD-MM-YYYY'),'DD/MM/YYYY')
in load script where you use your datefield
try this in that load script
date(date#(datefield,'YYYY-MM-DD'),'DD/MM/YYYY') AS DateField
the date# function gives you same ormat and Date function gives you that format which you want
Hope it helps
The document properties set the default date format. If the value already has a format then it will keep that format. You can give the date the correct format in the script. Maybe you can specify the wanted format on the Number tab of the chart. If not you'll have to use the date() function to change the format: date(MyDateField, 'DD/MM/YYYY')
Hi All,
Thanks for your answer
but in my case i have 40 field type date their format "YYYY-MM-DD"
Many thanks
Best Regards,
Emteam
Hi,
Send sample data. What types of date you have
Hi Gysbert Wassenaar,
Thanks for your answer
but in my case i have 40 field type date their format "YYYY-MM-DD"
Many thanks
Best Regards,
Emteam
DATE(FIELDNAME,'DD/MM/YYYY')
OR
DATE#(FIELDNAME,'DD/MM/YYYY')