Jump to content

Get(Current Date) shows wrong format


This topic is 2845 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 

Link to comment
Share on other sites

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?

  • Like 1
Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 2845 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.