Hello everyone, when i use Get(Current Date) function its show right date format as based on system format. But set field to the "text" field its show the wrong format..

 

I want to set the same date format to the text field: 

 

Example: My system format is "dd/mm/yyyy".. when i put this to date to text field, Its show as "mm/dd/yyyy" 

 

Is that make sense and How do i resolve this issue 

Apparently, this is not a file you've created by yourself, but inherited from someone using the mm/dd/yyyy date format. Unfortunately, setting the file to "Always use current system settings" in File Options does not work perfectly. Your best option is to save a copy of the file as a clone (no records) and import your data into the clone.

 

Incidentally, why are you setting a text field to a date?

The purpose is some time I want to see particular date and sometime i want to see all dates.

 

So when I sent as "All" & CreateDate.. then can do filter all record as well as particular date. 

 

Am I correct ?

The purpose is some time I want to see particular date and sometime i want to see all dates.

 

So when I sent as "All" & CreateDate.. then can do filter all record as well as particular date. 

 

Am I correct ?

 

I don't know - I don't follow your description that well. Anyway, it's a side issue. Did cloning the file resolve your problem?

yes - the issue resolved