Date format

[RaimondsR]

Hi!

Maybe someone could help me to solve one problem. 

Time format, which comes from one report is dd.mm.yy hh:mm:ss (there is space before dd), what i should get is dd.mm.yyyy, maybe anyone could help with this?

At moment tried use those 2 formulas : 

Date(Date#( Datums,'DD.MM.YYYY')) as add_date,

Date(Floor(TimeStamp#(Datums,'DD/MM/YY hh:mm:ss')),'DD/MM/YYYY') as add_date,

Bouth formulas returns "-".

[Durgadevikumar]

Hi,

try,

Timestamp(Timestamp#(Datums,'dd.mm.yy hh:mm:ss'),'dd.mm.yy') as add_date

Regards,

DurgadeviKumar

[sunny_talwar]

May be this

Date(Floor(TimeStamp#(Trim(Datums), 'DD.MM.YY hh:mm:ss')),'DD/MM/YYYY') as add_date

[Brett_Bleess]

You have been provided two responses to your question, we would greatly appreciate it if you would close out the thread by using the Accept as Solution button on the post(s) that helped resolve things.  This gives the poster(s) credit for the help and lets other Members know what worked.  If you still have further questions, or did something else, please leave an update post, and if you did do something else, you can post what you did and use the Accept as Solution button on that post after posting...

Regards,
Brett