Date

[NavinReddy]

Hi All,

My dates should be like this format

how can i change format like(DD/MM/YYYY)

i tried Date# its not working for me

some one help me

plz find the attachment

thanks in advance,

rohith

[MayilVahanan]

Hi

Try like this

= Date(Date#(DateField, 'YYYYMMDD'),'DD/MM/YYYY')

or

If its already in date format.

= Date(Date(DateField, 'YYYYMMDD'),'DD/MM/YYYY')

Hope that helps

[Anonymous]

use the set command to set the date format and then try to use the date functions

SET DateFormat='YYYYMMDD';

once this format is set the data in the above format can be used in date function.

[NavinReddy]

Hi All,

Not working for both expressions

Thanks,

rohith

[MayilVahanan]

Hi

Is it.. Can u post a sample file

[NavinReddy]

Hi All,

Load

Date(Date#([Dat ],'YYYYMMDD'),'DD/MM/YYYY') as [Date]

Resident Date;

DROP Tables Date;

Im using these script to change format

Plz find the attachment like the way i m getting

some one help me

thanks in advance,

rohith

[tresesco]

Rohith,

It seems that your [Date Key] is a key field and present there in multiple tables. If it is so, i would suggest you to set your date format at the beginning of your script like:

Set DateFornat='DD/MM/YYYY'

that would be the easiest option to change the date format instead fo changing all of them in different tables. Otherwise, you can do it specifically at the front end as well. In a list box, select expression and there you write

=Date([Date Key] , 'DD/MM/YYYY')

[NavinReddy]

Hi All,

Set [Date]='DD/MM/YYYY'

Date([Date] , 'DD/MM/YYYY') in list box im using same expression

again im facing same issue

thanks in advance,

rohith

[NavinReddy]

hi vishwa,

sorry im not getting now also

Thanks,

rohiht

[priyav24 · Accepted solution]

Hi Rohit,

               Try this go to Settings -> Document Properties ->Number

Select the field in the left side and choose the format you want as show in the figure..

Regards,

Priya