My Visual Database — diff between two dates

Re: diff between two dates

null@example.com (v_pozidis) — Sun, 25 Jun 2023 14:50:25 +0000

Derek thank's for your help.!!!!!!

Re: diff between two dates

null@example.com (derek) — Sun, 25 Jun 2023 11:13:29 +0000

Hi,
Use one of these 3 options depending on whether you want the month to be numeric, short or long

  tnxdatecolumn(form1.tablegrid1.columns[1]).formatmask := 'mm yyyy';
  tnxdatecolumn(form1.tablegrid1.columns[1]).formatmask := 'mmm yyyy';
  tnxdatecolumn(form1.tablegrid1.columns[1]).formatmask := 'mmmm yyyy';

See attached.
Derek.

Re: diff between two dates

null@example.com (v_pozidis) — Sun, 25 Jun 2023 10:27:03 +0000

Thank's Derek.
The ideas coming one by one. In the tablegrid I like to get only the Month And The year and I use the FormatDateTime function but somewhere I fail.
FormatDateTime('mm-yyyyy',start). ???

Re: diff between two dates

null@example.com (derek) — Sat, 24 Jun 2023 12:45:30 +0000

Hi,
I prefer where possible not to hard-code anything so in the attachment, you can choose the number of days below which the row should be highlighted.
Derek.

Re: diff between two dates

null@example.com (v_pozidis) — Sat, 24 Jun 2023 11:44:38 +0000

Derek than you.
In case I like to have a color raw when the value is below zero is there a way to do that with some script in the calculated field ?

Re: diff between two dates

null@example.com (derek) — Fri, 23 Jun 2023 17:40:27 +0000

Hi,
Try using either the 'daysbetween' function in a script or a calculated field (see attached).
Derek.

diff between two dates

null@example.com (v_pozidis) — Fri, 23 Jun 2023 17:17:13 +0000

Hi all, How can I find how many days are passed between two dates when I know the start date and the end date. I like to create a Calculate field in a Tablegrid.
Thank you all