Topic: diff between two dates
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
My Visual Database → General → diff between two dates
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
Hi,
Try using either the 'daysbetween' function in a script or a calculated field (see attached).
Derek.
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 ?
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.
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). ???
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.
Derek thank's for your help.!!!!!!
My Visual Database → General → diff between two dates
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi