Finance | Project Operations, Human Resources, ...

what is the best way to enter date without worry about date format ?

(0) Share

Report

Posted on by VoltesDev

Hi guys,

just curious, when we enter date value which do not have calendar tools, for example in Filter on column, what is the better way of doing it, without worry about date format of the system like MM//DD/YYY or DD/MM/YYY. I tried to put as "I thought" to be the default way of system works, YYYYMMDD which turns out wrong, there is no default way.

Do we have some common rule for this date input or we should take a look what is the system date format and follow.

Thanks,

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: what is the best way to enter date without worry about date format ?

Hi VoltesDev,

Date format will work based on the Date format settings under User options >> Preferences >> Date time and Number format. If you set En-Us as language preference the default date format will be MMDDYYY. Like that it will vary.

Thanks,

Girish S.

Was this reply helpful? Yes No
VoltesDev on at

Like (0)

Report

RE: what is the best way to enter date without worry about date format ?

So meaning, there is no common way of type it, instead we need to take a look at User options, what is the current format ? This is a must, right ?

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (1)

Report

RE: what is the best way to enter date without worry about date format ?

Yes you can change the date format under edt or control options. But filter works only based on the user options.

Normally Date time and Number format will be empty - At that time default format is MMDDYYY.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

RE: what is the best way to enter date without worry about date format ?

Hi VoltesDev, In addition to Girish comment (which is correct I believe), please check this similar thread

community.dynamics.com/.../how-can-i-change-format-all-datetime-to-dd-mm-yy

Was this reply helpful? Yes No