need help

[mshailaja]

hi

i have date format like this

i need like this

[Anil_Babu_Samineni]

May be this

Date(Date#([Open Date],'M/DD/YYYY'),'DD-MMM-YYYY')

Or

Date(Date#([Open Date],'MM/DD/YYYY'),'DD-MMM-YYYY')

[Anonymous]

or if you have real dual dates yet  then

Date([Open Date],'DD-MMM-YYYY')

[Kushal_Chawda]

if you data is in actual Date format just set the variable like below

SET DateFormat='DD-MMM-YYYY';

[mshailaja]

Anyoneplease help

[dathathreya]

now your format is in DD-MM-YYYY so please change it into DD-MMM-YYYY

[Colin-Albert]

Here are some useful posts on how to format dates correctly.

Get the Dates Right

Why don’t my dates work?

[Anil_Babu_Samineni]

What help you wnt, Does all replies is not working for you? Can you describe more