• Registered: 2014-10-10
  • Posts: 156

Topic: Calculate field for Date

Sir,

i am using Calculate field for Date and in grid table it is showing date in following format.

2017-06-22 00:00:00.000

i need the date in the date farmat as 22-Jun-17.

how to write code to show date in above format.

the code i am using is...

(SELECT StudentDB.RegDate FROM StudentDB WHERE StudentDB.id = AddCourses.id_StudentDB) 

Regards

Nitin Ingale

2 Reply by derek (edited by derek 2017-07-29 16:51:30)

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,681

Re: Calculate field for Date

Hi Nitin,
I would use a calculated field with substring to reformat the date to how you need it to appear in the tablegrid.
Have a look at the attached example;  it's not very sophisticated, but it works!
Depending on how your date is held, you may need to adjust the substring parameters in the calculated field but the principle is the same.
Regards,
Derek.

Post's attachments

Attachment icon nitindates.zip 336.46 kb, 383 downloads since 2017-07-29 

  • Registered: 2014-10-10
  • Posts: 156

Re: Calculate field for Date

Sir,

I am not able to do,
I have update the file as I need the output in calculate field. please check file.

Regards
Nitin Ingale

Post's attachments

Attachment icon Calculate field for date and dropdown field.gif 237.51 kb, 223 downloads since 2017-07-30 

4 Reply by nitin.ingale08 (edited by nitin.ingale08 2017-07-30 08:09:04)

  • Registered: 2014-10-10
  • Posts: 156

Re: Calculate field for Date

Sir,

please find updated project file in attachment.

Regards
Nitin Ingale

Post's attachments

Attachment icon nitindates1.rar 295.62 kb, 358 downloads since 2017-07-30 

  • Registered: 2014-10-10
  • Posts: 156

Re: Calculate field for Date

sir,

I am still not able to solve the problem.

please help me

Regards

Nitin ingale

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Calculate field for Date

nitin.ingale08 wrote:

sir,

I am still not able to solve the problem.

please help me

Regards

Nitin ingale

Check it out

Post's attachments

Attachment icon nitindates1_fixed.zip 7.74 kb, 385 downloads since 2017-07-31 

Dmitry.
  • Registered: 2014-10-10
  • Posts: 156

Re: Calculate field for Date

Thank you very much Sir,

Have a good Day

Regards
Nitin Ingale

  • Registered: 2014-10-10
  • Posts: 156

Re: Calculate field for Date

Sir,

Status drop down menu creating more than two entry,

How to solve this problem or query?

Please find attach file.

Regrad

Nitin Ingale

Post's attachments

Attachment icon Status.gif 104.28 kb, 200 downloads since 2017-08-01 

  • Registered: 2014-10-10
  • Posts: 156

Re: Calculate field for Date

Sir,

Status drop down menu creating more than two entry,

How to solve this problem or query?

Please find attach file.

Regrad

Nitin Ingale

Post's attachments

Attachment icon nitindates1_fixed1.rar 296.24 kb, 386 downloads since 2017-08-01 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Calculate field for Date

nitin.ingale08 wrote:

Sir,

Status drop down menu creating more than two entry,

How to solve this problem or query?

Please find attach file.

Regrad

Nitin Ingale

Unfotunately I can't understand your question.

Dmitry.

11 Reply by nitin.ingale08 (edited by nitin.ingale08 2017-08-02 04:56:02)

  • Registered: 2014-10-10
  • Posts: 156

Re: Calculate field for Date

Sir,

I want to search data with respect to status Combo-box.

when I click on status Combo-box, the list in Combo-box showing more than two entry,

In status Combo-box list showing list component as...

Active - 2 entry

In Active  -2 entry

And Close - 3 entry

and status list is increasing as new data entry added.

Please check Status Combo-box list, should show only 3 entry.

List should be only 3 component , that is Active , In Active And Close.

How to solve this problem or query?

Please download above file nitindates1_fixed1.rar file. i have created search in that file.

Please check both search, Course DashBoard and Book DashBoard.

Regards
Nitin Ingale

Post's attachments

Attachment icon Status.gif 158.44 kb, 198 downloads since 2017-08-01 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Calculate field for Date

For ComboBox1 set properties
ForeignKey = people.id_Status
FieldName = Status

Dmitry.