11-18-2022, 02:37 PM
It really depends heavily on what you want/need to do with it now or in the future.
If you manage/use it only in your QB-program, a random-file with a type-structure could work very well.
If you are yet unsure how you'll want to use the data in the long run, I'd opt for a 'output append' style csv, which you can open in excel any time to do your sorts/filters/graphs etc.
For storing the date you also have several options depending on the use:
'any local format' if it is only used for human reading
yyyymmddhhmmss if you want to stay flexible in formatting and sorting
epoch timestamp if you need to calculate with it (days=finish-start, hours=days*24, etc)
Depending on your needs/choices I can provide you with some functions for csv's (fields,io,sorts) and epoch date/time
If you manage/use it only in your QB-program, a random-file with a type-structure could work very well.
If you are yet unsure how you'll want to use the data in the long run, I'd opt for a 'output append' style csv, which you can open in excel any time to do your sorts/filters/graphs etc.
For storing the date you also have several options depending on the use:
'any local format' if it is only used for human reading
yyyymmddhhmmss if you want to stay flexible in formatting and sorting
epoch timestamp if you need to calculate with it (days=finish-start, hours=days*24, etc)
Depending on your needs/choices I can provide you with some functions for csv's (fields,io,sorts) and epoch date/time
45y and 2M lines of MBASIC>BASICA>QBASIC>QBX>QB64 experience